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?