Hello:
I need some help. I have a spreadsheet that has the following values
Cell A1 - Joe Smith
Cell A2 - 123 Main Street
Cell A3 - Anywhere, PA 19033
Cell A4 - Blank
Cell A5 - Jane Doe
Cell A6 - 456 State Street
Cell A7 - Somewhere, PA 19045
And this goes on to create a very long list of names and addresses. I would like to seperate the list so that column A is first name, column B is last name, column C is the street address (ie. 123 Main St), column D is the city, column E is the state, and column f is the zip code. I am familiar with how to seperate if all of column a contained first and last names, but I can't figure out how to seperate this when there are addresses in the rows. This is how the data was given to me, I didn't create it this way!!! Can anyone help? Thanks in advance.
Jeff
I need some help. I have a spreadsheet that has the following values
Cell A1 - Joe Smith
Cell A2 - 123 Main Street
Cell A3 - Anywhere, PA 19033
Cell A4 - Blank
Cell A5 - Jane Doe
Cell A6 - 456 State Street
Cell A7 - Somewhere, PA 19045
And this goes on to create a very long list of names and addresses. I would like to seperate the list so that column A is first name, column B is last name, column C is the street address (ie. 123 Main St), column D is the city, column E is the state, and column f is the zip code. I am familiar with how to seperate if all of column a contained first and last names, but I can't figure out how to seperate this when there are addresses in the rows. This is how the data was given to me, I didn't create it this way!!! Can anyone help? Thanks in advance.
Jeff