| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Seperate the data in two columns
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Seperate the data in two columns
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 DataText to Columns Select DelimitedNextCommaFinish Biff "F.G." wrote in message oups.com... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I seperate a full name field out into three seperate columns? | Excel Worksheet Functions | |||
| seperate first 2 lines of column in seperate columns in same row | Excel Discussion (Misc queries) | |||
| Seperate Data in one column into two columns? | Excel Worksheet Functions | |||
| Import data into seperate columns | Excel Discussion (Misc queries) | |||
| How do I seperate data in one column into multi columns | Excel Worksheet Functions | |||
Hybrid Mode
