How do I format text, like Medicare number

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Code Doctor - 26 May 2006 01:21 GMT

I have in Excel a text field that contains unformated Medicare numbers, ie
123456789A. In a mail merge, using that field, I want the display to look
like 123-45-6789A.

Reply to this Message

Graham Mayor - 26 May 2006 05:14 GMT

You are not going to be able to format the field in Word while the 'A' is
present in the number. Create a new column in the Excel table and separate
the number from the letter, then you can combine the fields to produce the
layout eg
{MergeField MediNumber \# "000'-'00'-'0000"}{Mergefield Suffix}

See http://www.gmayor.com/formatting_word_fields.htm

Signature

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> I have in Excel a text field that contains unformatted Medicare
> numbers, ie 123456789A. In a mail merge, using that field, I want the
> display to look like 123-45-6789A.

Reply to this Message

Doug Robbins - Word MVP - 26 May 2006 05:23 GMT

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/formatting_word_fields.htm

But that may not work in your case because of the alpha-numeric data in
Excel.

As a result, you may have to insert the hyphens into the data in Excel,
which can be done by use of a formula

Left(cellreference, 3)&"-"&Mid(cellreference, 4, 2)&"-"&Right(cellreference,
5)

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I have in Excel a text field that contains unformated Medicare numbers, ie
> 123456789A. In a mail merge, using that field, I want the display to look
> like 123-45-6789A.

Reply to this Message