Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text-To-Colums Help, Please!
I have the following types of text in one column on multiple rows that I need
separated in to it's own column for each letter. The only problem is there is no delimiter between each letter. Example "ACCDACBDDDABDAADBBCAABAADBCDDBADBAA" I need it to be separated like "|A|C|C|D|A|C|" Now I know this can be done manually but i have to click each break by hand which turns in to 30-40-50 clicks for each document, and there are hundreds of documents to be done just like this one. Is there a shortcut, it would be so much easier if i could just right arrow and press space bar to insert the breaks instead of manually clicking each one. Anyone have a solution to this problem? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text-To-Colums Help, Please!
Aaron
With your text in A1 put this in B1 and drag right aS FAR AS REQUIRED =MID($A$1,COLUMN(A1),1) mIKE "Aaron" wrote: I have the following types of text in one column on multiple rows that I need separated in to it's own column for each letter. The only problem is there is no delimiter between each letter. Example "ACCDACBDDDABDAADBBCAABAADBCDDBADBAA" I need it to be separated like "|A|C|C|D|A|C|" Now I know this can be done manually but i have to click each break by hand which turns in to 30-40-50 clicks for each document, and there are hundreds of documents to be done just like this one. Is there a shortcut, it would be so much easier if i could just right arrow and press space bar to insert the breaks instead of manually clicking each one. Anyone have a solution to this problem? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Problems; in writing macro and convert text to colums | Excel Discussion (Misc queries) | |||
Text to colums | Excel Discussion (Misc queries) | |||
Text to Colums | Excel Discussion (Misc queries) | |||
Text to Colums | Excel Discussion (Misc queries) | |||
text spilling over text and colums | Excel Discussion (Misc queries) |