Data column has a mix of text and numbers

[harg7769]

I am trying to print labels using an excel spreadsheet as the data
source. One fo the fields is the House number. Some of the house
numbers also haver a flat position incorporated, eg 62a High Street.

When I try to merge the fields, the ones with a letter in them are
merging as 0. Is this because Word is assuming that the field should
be a number field like all the other records, and so automatically
assigns it a value of 0? If so, how do I fix it?

Regards

Andrew H

 

[Graham Mayor]

See the Excel data section of
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP

Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

 

[harg7769]

Thanks Graham - perfect.