Change the format of a mailing list imported from Corel WP

Hi ExcelReRe,

Welcome to the forum and to a problem I've had many times. There is no perfect formula (that I've found) for this problem. You can =Trim() your data to remove leading and trailing spaces. You might also =Clean() your data as you'll never see those unprintable characters hiding in the text.

Now for a partial answer:

On the first row where Dr. Harris is, lets say he is in A1 you put a formula in B1 = A2, In C1 = A3, In D1 = A4 etc.
You then copy the formulas in B1 to G1 down to the next row that has a new name.
This saves some time but still ends up needing to comb through your data by hand in the end.

There are other tricks to extract the city state and zip into their own fields.

Be aware that you will need to copy and paste values only to another sheet or columns in your sheet before you delete column A data.

I hope this helps some. If everyone had the same format for keeping addresses it would be a lot easier.

Lets say the address are all formatted the same. What could I do to make it easier. And can you elaborate more on the =a1 =b2 I am trying that but its really not working.