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