Split one coloumn into 2 in Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ingve@reslab.no - 29 Mar 2007 11:39 GMT

Hi,

I have an excel spreadsheet where I have a lot of values in coloumn A.
I want to split this into A and B. ( like a snake )

Coloumn A have: 1000, 1001, 1002, 1003 etc
I want to have A: 1000, B: 1001, A: 1002, B: 1003 etc

Is there an easy way to do this?

Reply to this Message

Douglas J. Steele - 29 Mar 2007 12:22 GMT

This newsgroup is intended for questions about Access, the databsae product
that's part of Office Professional.

I'd suggest reposting your question to a newsgroup that's related to Excel.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Hi,
>
[quoted text clipped - 5 lines]
>
> Is there an easy way to do this?

Reply to this Message

ExcelEd - 29 Mar 2007 12:58 GMT

Hi
Try Text to Columns
This can be found in the Data Menu, if your data is delimited by commas it
should be fairly straightforward

> Hi,
>
[quoted text clipped - 5 lines]
>
> Is there an easy way to do this?

Reply to this Message