Format cell conditional numeric and text

C

Cyndy TN

Simple question I'm sure. Trying to format cell with both numeric & text.
Phone number + alpha. (123) 123-12324 H
Have tried: (###) ####-#### @ also with ; and _
Can't find solution

Thanks
 
D

Dave Peterson

Number formats only work with numbers--not text.

You could use a helper column that displays it nicely.

If you type
1231231234H
in A1
you could use this in B1:
=TEXT(LEFT(A1,10),"(000) 000-0000 ")&RIGHT(A1,1)

And drag down.
 
Top