Greetings!
I have received an Excel spreadsheet that is to be prepared for a bulk mailing. My mailing software requires that names, addresses, cities, etc be in separate columns to be imported. My problem is this: the spreadsheet has all of the information in one column with each item listed in a separate row. For example:
=================
Full Name
Address
City, State Zip
=================
To complicate things further, sometimes additional family members are included and need to be deleted. These are always denoted by having a bracket as the first character of the row, like this:
=================
Full Name
[Family Member 1
[Family Member 2
Address
City, State Zip
=================
What I'm looking to do is separate them out into columns, like this:
Full Name Column Address Column City State Zip Column
The records are broken up by a series of dashes, like this:
--------
Full Name 1
Address 1
City State Zip 1
--------
Full Name 2
Address 2
City State Zip 2
--------
Full Name 3
Address 3
City State Zip 3
I have attached a screenshot of the column from my actual spreadsheet. Every row that contains a "(" character needs to be deleted as well. The only thing I've been able to do is copy and paste everything by hand, but this spreadsheet is very large (about 66,000 rows) and has taken me hours to do just a few thousand. Any help with this issue is greatly appreciated.
Bookmarks