Split one coloumn into 2 in Excel

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?
 
D

Douglas J. Steele

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.
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Simple distinct count Query 1
query 1
Select Query With Parents And Child's In one row 11
numbering in ascending order 3
ADO excel VBA to update data in Access 3
Exported data to Excel 2007 has spaces between rows 1
Standand Deviation as array 6
Replace Date 3

Top