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