| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I extract the first & last name separated by a comma
Hi
I have a column A which has first and last name separated by a comma as follows: *Cloumn A* Bernhardt,Gail Wygonik, Mark Patel,Arpna Now, what I need is to be able to separate the two into 2 columns so I can get, col. B and C: *Col B* *Col C* Bernhardt Gail Wygonik Mark Patel Arpna Thanks for your help! MSA |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing a comma separated text file and save it. | Excel Discussion (Misc queries) | |||
| combine rows into one cell separated by comma | Excel Discussion (Misc queries) | |||
| how could I import a text file with comma separated values into ex | Excel Worksheet Functions | |||
| Count comma separated numbers, numbers in a range with dash, not t | Excel Discussion (Misc queries) | |||
| Going from column to comma separated list... | Excel Discussion (Misc queries) | |||
Threaded Mode
