Seperate the data in two columns

F

F.G.

Hi,
I have a column:
Lastname1,Firstname1
Lastname2,Firstname2
Lastname3,Firstname3

Is it possible to create a formula to seperate the data in two
columns.
Column x Columny
Lastname1 Firstname1
Lastname2 Firstname2
Lastname3 Firstname3

Thanks for help

Regards,,
Faruk Gashi
CUNY
 
T

T. Valko

Assume that data is in column A.

Make sure column B is empty. Insert a new column B if needed.

Select the data in column A
Goto the menu Data>Text to Columns
Select Delimited>Next>Comma>Finish

Biff
 

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

how to seperate cell contents into two cloumns ? 4
instr for select Query 8
Moving columns into rows 1
Insert Rows 1
How to eliminate duplicate information in report 5
Query with multiple Not In criteria 1
Putting data from multiple worksheets into one 3
how i use countif and AND? 11

Top