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

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

"Raja" wrote:

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?