View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Splitting a delimited text

There is a text to columns feature available.

Make sure the columns to the immediate right are empty. Any data in them
will be overwritten.

Select the cells in question
Goto the menu DataText to Columns
DelimitedNext
CommaFinish

Biff
Microsoft Excel MVP

"atledreier" wrote in message
ups.com...
Hello again.

I have a cell with data, delimited by a comma. The data is text.
I need to get this data split into individual cells. Any neat way to
do this automated?