| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Spilting a column
I am trying to merge mailing spreadsheets, and the one I am building has
first name & last name columns, but my issue is that many of the other spreadsheets have only one column for a name (smith, bob). Is there a way to create a method to use the comma in between the "smith, bob" to separate the data into 2 columns? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Referencing date column A & time column B to get info from column | Excel Discussion (Misc queries) | |||
| spilting columns | Excel Discussion (Misc queries) | |||
| Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
| Spilting Data in the same cell | Excel Discussion (Misc queries) | |||
| Spilting 1 cells contents into 5 columns over an entry of 1 to five characters | Excel Discussion (Misc queries) | |||
Threaded Mode
