Assuming the original numbers are always 1 alpha and 10 numeric digits, this
should work...
=LEFT(D6,1) & TEXT(VALUE(RIGHT(D6,9)),"000-0000-0000")
Francis J Hayes (The Excel Addict)
www.TheExcelAddict.com
Helping Average Spreadsheet Users
Become Local Excel Experts
"cliff" wrote:
Hi, I need to format text and numbers, but I keep messing up.
For example, I want to format
A12345678901 so that it will appear as
A123-4567-8901
Please help?