Sep 28 2023 06:18 PM
I need help formatting a bunch of phone numbers from this (916) 123-4567 to adding a 119161234567.
Sep 28 2023 06:19 PM
Sep 28 2023 07:33 PM
SolutionYou can use Excel's built-in functions to format phone numbers as you described. Here's a step-by-step guide on how to add "1" in front of phone numbers like (916) 123-4567:
Assuming your phone numbers are in column A:
=CONCATENATE("1", SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1, "(", ""), ")", ""), "-", ""), " ", ""))
This formula removes the parentheses, hyphen, and adds "1" in front of the remaining digits.
Excel will apply the formula to each cell in column B, creating the formatted phone numbers with "1" in front of them.
Now, column B will contain the phone numbers in the format you specified (e.g., 19161234567). You can copy and paste these values if you want to remove the formulas and keep only the formatted numbers. The text and steps were edited with the help of AI.
My answers are voluntary and without guarantee!
Hope this will help you.
Was the answer useful? Mark them as helpful and like it!
This will help all forum participants.
Sep 28 2023 07:46 PM
Sep 28 2023 07:33 PM
SolutionYou can use Excel's built-in functions to format phone numbers as you described. Here's a step-by-step guide on how to add "1" in front of phone numbers like (916) 123-4567:
Assuming your phone numbers are in column A:
=CONCATENATE("1", SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1, "(", ""), ")", ""), "-", ""), " ", ""))
This formula removes the parentheses, hyphen, and adds "1" in front of the remaining digits.
Excel will apply the formula to each cell in column B, creating the formatted phone numbers with "1" in front of them.
Now, column B will contain the phone numbers in the format you specified (e.g., 19161234567). You can copy and paste these values if you want to remove the formulas and keep only the formatted numbers. The text and steps were edited with the help of AI.
My answers are voluntary and without guarantee!
Hope this will help you.
Was the answer useful? Mark them as helpful and like it!
This will help all forum participants.