Split one coloumn into 2 in Excel

  • Thread starter Thread starter ingve
  • Start date Start date
I

ingve

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?
 
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.
 
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
 
Back
Top