Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting and seperating commas
Ok here what I need to do. In column 1 I have five rows of names first and
last names seperated by a comma.....example Smith, Joe (all in one column). I need to take the comma out and put Smith in column 1 and Joe in a new column or column 2 by itself. Therefore I need Smith (in Column A) Joe (in column B). Thanks for the help. Please give me step by step on how to do this. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seperating two excel applications | Excel Discussion (Misc queries) | |||
Seperating buy Tabs | Excel Worksheet Functions | |||
Seperating text | Excel Discussion (Misc queries) | |||
Seperating First and Last Names | Excel Discussion (Misc queries) | |||
Seperating worksheets | Excel Discussion (Misc queries) |