| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delimit using 2 spaces instead of 1?
You can use Find and Replace to replace two spaces by a special character (^?) and use that as a delimiter in Text to Columns
-- Kind regards, Niek Otten Microsoft MVP - Excel "J@Y" wrote in message ... | Say I have a lline of text: | | The dog 's name is Mike. | | How is it possible to separate that into two columns, split between "is" and | "Mike"? Delimiter can't be set to " than 2 spaces" for text to column. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delimit using a formula 2 | Excel Discussion (Misc queries) | |||
| delimit using a formula | Excel Discussion (Misc queries) | |||
| Imported Data, How to delimit correctly | New Users to Excel | |||
| Best way to delimit text file | Excel Programming | |||
| Why is delimit failing me _now_??? | Excel Programming | |||
Threaded Mode
