Extracting Text from a Cell

T

Tony

I have a column in excell that has 1-4 names in each cell.
I would like to extract the names into 4 seperate cells
(column). The names are seperated by a comma and a soft
return.

I'd appreciate any help.
 
B

Bob Phillips

Look at Data>Text To Columns

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
M

mzehr

Tony,
If there is a soft return in the cell, such that each name
appears above the next, with a comma after each name, you
may need to insert a helper column use the following
formula (assumes your data is in A1) =Clean(a1). Copy
that formula down in your helper column, then copy and
paste the values. This will eliminate the return
character, then you can use the Data>Text to Columns
feature

HTH
 
Top