Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am using delimited text-to-columns in Excel 2003. I would like to
break up a single text column into two additional text columns based on the 1st two occurances of the space delimiter (" ") within each cell. All other spaces should be ignored. Finally, for what remains fo the original column, I'd like to break it into an additional column based on the last occurance of the colon delimiter (":"), with any other colons ignored. Is there a way to do this? Before I imported the text into Excel, I could have made the job easier by replacing the 1st 2 spaces, and the last colon, in the text into a special delimiting character which occurs nowhere else, such as "@". It would be a big step backward to go back to the external text file because I've already done a lot of grouping of rows into an outline structure (it's a somewhat hefty file with many levels of groupings throughout). Perhaps I can preserve the outline structure by re-importing the text into adjacent columns (after injecting the unique delimiting character)....Hmmmm..... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to Export as text file with NO delimiters or modifications? | Excel Discussion (Misc queries) | |||
Importing text file with no line delimiters | Excel Discussion (Misc queries) | |||
Export (or save as) .csv with text delimiters | Excel Discussion (Misc queries) | |||
How To Import Text File With No Delimiters? | Excel Discussion (Misc queries) | |||
How do I get carriage returns to not be row delimiters in text fi. | Excel Discussion (Misc queries) |