| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delimit using 2 spaces instead of 1?
That's a brilliant, thanks guys!
"Tom Ogilvy" wrote: Sorry, I was focused on the expanse between the two sections and misinterpreted what you were asking. You could do an Edit=Replace on the column and replace 2 or perhaps 3 spaces with a semi colon or something like that. then do text to columns. -- Regards, Tom Ogilvy "J@Y" wrote: 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
