I have an Excel spreadsheet with address infomation that I'm mail merging
labels. Some of the label address' have a lot of space between the first
name and last name. How can I correct this problem without having to go
through each address.

You haven't told us how your data are arranged, but look at Help for TRIM,
CLEAN, and "Remove spaces and nonprinting characters from text"
--
David Biddulph

"gloria81101" wrote in message
...
I have an Excel spreadsheet with address infomation that I'm mail merging
labels. Some of the label address' have a lot of space between the first
name and last name. How can I correct this problem without having to go
through each address.

Hi,

If you are using Microsoft Excel Worksheet to merge with Microsoft Word
document then, Microsoft Word document adjust the Field content according to
the empty content in Word document.

If the enclosed Chevron doesnot find any information for a particular field,
then the spacing gets adjusted automatically.

Challa Prabhu

"gloria81101" wrote:

I have an Excel spreadsheet with address infomation that I'm mail merging
labels. Some of the label address' have a lot of space between the first
name and last name. How can I correct this problem without having to go
through each address.