Thread: De-concatenate?
View Single Post
  #3   Report Post  
Duke Carey
 
Posts: n/a
Default

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.