Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
I would like to format all input numbers to have the same format (xxx) xxx-xxxx
There is not a built in phone number format - these numbers will need to be formatted manually.
You could use a concatenate formula in a new column to do this automatically for you.
Try this formula:
="(" + LEFT(Text13, 3) + ") " + MID(Text13, 4, 3) + "-" + RIGHT(Text13, 4)
Text13 is the cell containing the phone number in this example and will turn this:
2068675309
To this:
(206) 867-5309
I use to be anal about that until I started calling German friends. Their system does not have a fixed length. Bernt's number is 201 345678 and Simone's number is 177 232 23286. (Don't call them)
My brain still hurts when I think about it.
Craig
Don't put the formula into cell Text13.
You need two columns, one with the raw data, one with the formatted data.
I keep getting a #CIRCULAR REFERENCE error trying to get that concatenate formula to work. So, the only way to do it is with two columns - one unformatted and one with forumula.? Please tell me there is a better way.
