Hi all!
I need to create mailing labels with a list of data I've received. My lines have one, two, or three names. I tried to Convert Text to Columns, but there are just spaces separating the text.
Here's an example from my list:
Paul & Joan & Marjorie Roderick 75 E. Charles Street Long Branch, NJ 08005
This is how my label should look:
Paul & Joan & Marjorie Roderick
75 E. Charles Street
Long Branch, NJ 08005
Any ideas/help is greatly appreciated!
I need to create mailing labels with a list of data I've received. My lines have one, two, or three names. I tried to Convert Text to Columns, but there are just spaces separating the text.
Here's an example from my list:
Paul & Joan & Marjorie Roderick 75 E. Charles Street Long Branch, NJ 08005
This is how my label should look:
Paul & Joan & Marjorie Roderick
75 E. Charles Street
Long Branch, NJ 08005
Any ideas/help is greatly appreciated!