| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Delimiters in Text to Columns
I'm seperating out first and last names using the Text to Columns feature. However, using the space delimiter, if there are double last names that are not connected by a hyphen, it gives me a completely new column. Is there a way to keep the 2nd last name in the same column as the first last name without concatenating the 2 last name columns together again?
Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Use of multiple-character delimiters under Text To Columns | Excel Discussion (Misc queries) | |||
| Text-to-columns, but only 1st 2 & last delimiters | Excel Discussion (Misc queries) | |||
| Text to Columns with multi-character delimiters | Excel Programming | |||
| How To Import Text File With No Delimiters? | Excel Discussion (Misc queries) | |||
| Text to columns -- reset delimiters, etc | Excel Programming | |||
Linear Mode
