Excel 2007 : Split Cell Contents into Separate Columns

Gud Morning..

Happy New Year...

I need one help in Excel 2007. In excel 2007 one column I have Name below that phone number, I want to separate Phone number & Name. Is there any way to separate the same?

Thanking you.

With Best Regards

Lokesh Kamath

I'm guessing that each cell contains a name, a line-feed, and a phone number.

If that's true...try this:

Please Login or Register  to view this content.

That will split each cell's name and phone into two columns

Is that something you can work with?