Solved: Excel problem - splitting the contents of cells

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Marty999

Thread Starter
Joined
Nov 2, 2007
Messages
14
I have been asked to print 300 address labels from an Excel document, I was going to do a mail merge from Word but the originator has entered the addresses all in one cell per record. There are no commas separating the elements, only spaces. Is there an easy way to split this out so that I end up with Add1, Add2, postcode etc all in their own columns?
 
Joined
Sep 4, 2003
Messages
4,916
Look at the "Text to Columns" feature in Excel. You should be able to use this and split the data using a space as the delimiter. If this doesn't work for you please post a sample workbook so we can see what we are dealing with.

Regards,
Rollin
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top