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?

IF ?? each company is a single word a simple datatext to
columnsdelimitedspace should do it.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Raja" wrote in message
...
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?

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?