Excel

[Guest]

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?

 

[Don Guillett]

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

 

[Guest]

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

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