The number part as well as the alpha part can be anynumber and any alpha. It
is a trace code for medical billing, but the format will always be the same.

"Rick Rothstein (MVP - VB)" wrote:

Is the "number" part always going to be 07-108029827? In other words, what
do you want to TYPE into the cell and what do you want appear? If the number
part is not the same all the time, where is it coming from?

Rick

"Rick" wrote in message
...
Is there anyone out there that can tell me how to create a format that
does
this:
07-108029827-A it's the A that needs to be a substitue alpa character,
because the A may have to be a B, or C, or D.

Thanks