We’d like to remind Forumites to please avoid political debate on the Forum.
This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
The Forum now has a brand new text editor, adding a bunch of handy features to use when creating posts. Read more in our how-to guide
Excel problem - splitting the contents of cells
Marty999
Posts: 728 Forumite
in Techie Stuff
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?
0
Comments
-
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?
Highlight the cell then Data, then Text to columns. You could write a simple macro to automate this.:doh: Blue text on this forum usually signifies hyperlinks, so click on them!..:wall:0 -
Thanks Espresso, that helps!
Marty.0
This discussion has been closed.
Confirm your email address to Create Threads and Reply
Categories
- All Categories
- 354.2K Banking & Borrowing
- 254.3K Reduce Debt & Boost Income
- 455.3K Spending & Discounts
- 247.1K Work, Benefits & Business
- 603.8K Mortgages, Homes & Bills
- 178.4K Life & Family
- 261.3K Travel & Transport
- 1.5M Hobbies & Leisure
- 16.1K Discuss & Feedback
- 37.7K Read-Only Boards