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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Format a number in a scecial way 8
Numbers as Text 1
Number Format 5
Formatting Phone Numbers in Excel 2007 Help 15
IF Function 2
Sorting 0
Remove formatting from SSN 3
Telephone masking in int'l format 1

Back
Top