Format cell conditional numeric and text
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.
Cyndy TN wrote:
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
--
Dave Peterson
|