Home |
Search |
Today's Posts |
#1
|
|||
|
|||
De-concatenate?
Is there a way to de-concatenate a cell? I have cells which contain 5-letter
abbreviations (ex. a cell might have "GGGGG TTTTT GTCTG") and I'm trying to find a way to seperate these into seperate cells. Is there a function or process that makes this easier than doing it manually? Any help would be apreciated. |
#2
|
|||
|
|||
Try the text to columns feature... Data-Text To Columns
In your example, it looks like each abbreviation is separated by a space, so choose Delimited and check "Space" -- Regards, Dave "KevinMB" wrote: Is there a way to de-concatenate a cell? I have cells which contain 5-letter abbreviations (ex. a cell might have "GGGGG TTTTT GTCTG") and I'm trying to find a way to seperate these into seperate cells. Is there a function or process that makes this easier than doing it manually? Any help would be apreciated. |
#3
|
|||
|
|||
Data-Text to Columns-Delimited - and indicate that the delimiter is a space
Make sure you have empty columns to the right of your data, as it will overwrite anything there "KevinMB" wrote: Is there a way to de-concatenate a cell? I have cells which contain 5-letter abbreviations (ex. a cell might have "GGGGG TTTTT GTCTG") and I'm trying to find a way to seperate these into seperate cells. Is there a function or process that makes this easier than doing it manually? Any help would be apreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF, IF, Concatenate? | Excel Worksheet Functions | |||
Using Concatenate inside a vlookup | Excel Worksheet Functions | |||
Match and Concatenate ?? | Excel Worksheet Functions | |||
COPY A CONCATENATE CELL TO BLANK CELL PUTTING IN THE NEXT BLANK C. | Excel Discussion (Misc queries) | |||
Concatenate cells without specifying/writing cell address individually | Excel Discussion (Misc queries) |