Excel

R

Raja

I have data that has been entered by someone. The person has entered lots of
company's names in a single cell. I need to extract the individual companies
on to another cells!! What's the best thing of doing this?
 
D

Don Guillett

IF ?? each company is a single word a simple data>text to
columns>delimited>space should do it.
 
T

tim m

Try 'Data'.....'text to columns'....'delimited'

you will then have to choose something to seperate them by, probably a space
or something like that.
 
Top