I have a very large list in Excel that contains about 3500 companies. The list includes 8 columns (Company Name, Prefix, First Name, Last Name, Street , City, State, Zip). When I do a data merge with Word to create mailing labels it comes out somewhat messed up. It looks somethiing like this:
ABC Company
Mr.________John_______Doe
City Name,_______CA_________44065
The "__________" are not visiable on the labels but are used to represent the long spaces between the words.
After trying to figure out why I had all these extra spaces on my labels I went back to my Excel spreasheet and realized I have several blank spaces after each word in my columns. Using the example above I would have "City Name" followed by a bunch of black spaces as if I'd hit the space bar several times after entering "City Name". I found out that when I deleted the extra spaces and did the data merge for mail lables again the problem was resolved. Of course to go into something like 10,000 cell to remove the blank spaces would take forever so mu questions is this. Is there are way to somehow globally, or by column remove the blank spaces without having to go back to each cell and do it manually? If anyone could tell me how resolve this that would be great!
ABC Company
Mr.________John_______Doe
City Name,_______CA_________44065
The "__________" are not visiable on the labels but are used to represent the long spaces between the words.
After trying to figure out why I had all these extra spaces on my labels I went back to my Excel spreasheet and realized I have several blank spaces after each word in my columns. Using the example above I would have "City Name" followed by a bunch of black spaces as if I'd hit the space bar several times after entering "City Name". I found out that when I deleted the extra spaces and did the data merge for mail lables again the problem was resolved. Of course to go into something like 10,000 cell to remove the blank spaces would take forever so mu questions is this. Is there are way to somehow globally, or by column remove the blank spaces without having to go back to each cell and do it manually? If anyone could tell me how resolve this that would be great!
