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.

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.

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.