Address in One Cell with spaces to create line breaks

E

epam06

Hi,

I have contact information in one cell. The lines of the contact
information are seperated by multiple spaces. I need to split each line
into a seperate cell. Can you suggest a way to do this?

The data looks like this:

The Mayo Clinic, PA (followed by many spaces)
John Doe, MD (followed by many spaces)
500 Hooha St., Suite 171(followed by many spaces)
Dept. XYZ - 14(followed by many spaces)
Big City, CA 98888(followed by many spaces)
Phone: (555) 555-1212(followed by many spaces)
Fax: (555) 555-1212(followed by many spaces)
[email protected]

Thanks in advance for any help!
Pam
 
J

Jim Gordon

Hi,

Try this: Select the cell then use the DATA menu and choose TEXT TO COLUMNS.

-Jim Gordon
Mac MVP
 
J

Jan Putcuyps

Hi Pam,

Are there any returns in the data within the cell, or is this one long
string just separated by spaces? If the data includes returns, you can copy
it to word, select the data within word and re-copy it to xl. It should
appear in separate cells now.

If the data is only separated by many spaces (one long string), you can use
the 'text to columns' tool.

Jan
 
E

epam06

hey, I found an answer today at work. find two spaces, replace with 1
hash, find two hashes, replace with 1, repeat until 1 hash remains . .
then, use text to columns

Thanks,
epam
 
Top