The Problem
Raw phone numbers are technically usable, but they are not pleasant to scan. A block like 1234567890 takes more effort to read than a number broken into the familiar phone pattern.
This challenge is about presentation as much as accuracy. We want the sheet to turn plain digits into a standard display format, then confirm the source value has the expected length.
How We Solve It
The quickest route is TEXT with a custom mask. That lets Excel display the number as (###) ###-#### without us manually slicing and rebuilding each piece.
Method 1: TEXT with a phone mask
Method 1: Apply one custom mask to the full 10-digit number.
This is the method used in the solution. The pattern tells Excel where the parentheses, space, and dash should go, so every 10-digit value is displayed in the same readable style.
This solves the challenge directly because the worksheet needs the raw digits to turn into one consistent phone layout in column B. Once the mask is applied, the numbers become easier to read without having to rebuild the text manually.
=TEXT(A2, "(###) ###-####")
Method 2: Build the format manually
Method 2: Build the format piece by piece when you want more control.
If you need a custom layout, you can pull out the area code, middle block, and last four digits separately, then join them back together with text symbols. It is longer than TEXT, but it gives more direct control over each part.
This solves the same formatting problem in a more hands-on way. It is useful when the layout might change later, because each part of the number can be adjusted separately before the final string is joined together.
="("&LEFT(A2,3)&") "&MID(A2,4,3)&"-"&RIGHT(A2,4)
Method 3: Insert separators with REPLACE
Method 3: Insert separators into fixed positions with REPLACE.
This method works well when the goal is just to add separators into a fixed-length string. It is another useful cleanup pattern, even though the challenge itself expects the parenthesized phone format.
This solves a simpler presentation problem where the sheet only needs readable separators, not a full phone mask. It is a good option when the source data is clean and the main goal is to break the number into more readable chunks.
=REPLACE(REPLACE(A2, 4, 0, "-"), 8, 0, "-")
Function Explanation
1. TEXT
TEXT formats a value according to a pattern you provide. In this file, that pattern turns a 10-digit number into a standard phone display.
Learn more this functionTEXT
2. LEN
LEN counts characters in the raw input. We use it in the summary to confirm the first value has 10 digits before formatting.
Learn more this functionLEN
3. COUNTA
COUNTA counts non-empty cells. Here it tells us how many formatted results exist in column B.
Learn more this functionCOUNTA
Formatting formulas improve readability, but they do not fix bad input by themselves. If the source data has missing digits, the result can still look wrong, so validation and formatting often go together.
Format the raw digits in column A into standard phone numbers, then complete the two checks at the bottom so the sheet confirms the first value has 10 digits and counts how many formatted results were created.