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.