Number and text format in the same call

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to change the format of the following"

12345678
to
123-45-678 -- in other words, adding the dashes. Some of the numbers are the
same 8 digits, but also have a letter. They are currently:

12345678A
to
123-45-678A

Thank you,
 
In a helper column put this formula and copy down.....then do Copy >
PasteSpecial > Values on that helper column to eliminate the formulas and
delete the original column if desired.

=LEFT(A1,3)&"-"&MID(A1,4,2)&"-"&MID(A1,6,99)

Vaya con Dios,
Chuck, CABGx3
 
Back
Top