You can't merge part of a field - You would have to derive a new field in
your excel sheet containing the part of the data you require and merge that
field instead.
--
Graham Mayor - Word MVP
My web site
www.gmayor.com
Word MVP web site
http://word.mvps.org
"Cindy" wrote in message
...
Greetings, I am merging data from an excel spreadsheet onto labels in
Word
(2003). Is there anyway I can restrict a field size to only 5-6
characters
rather than the entire cell contents being merged onto the label?
Any suggestions would be greatly appreciated! Thanks!!