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.
|