Converting a number into particular format

[Harry_1234]

Hello,

What is the best way to convert following format into e.164 in excel i.e. i would like to convert numbers in the format 123 456-0001 to \+11234560001.
Column A Column B

123 456-0001 \+11234560001
123 456-0005 \+11234560005
123 456-1000 \+11234561000

 

[kennypete]

The B1 formula here should do the trick:

Book2
	A	B
1	123 456-0001	\+11234560001
Sheet1

Cell Formulas
Range	Formula
B1	B1	=INT(SUBSTITUTE(SUBSTITUTE(A1,"-","")," ",""))

You can either prepend the "\+1" or number format adding "\+1" (what I did here).
Whether this is the "best" way probably depends on factors that are not outlined here - e.g. I have presumed that the 123 456-0001 is text and not a representation presented by a formula, etc.

 

[Harry_1234]

The B1 formula here should do the trick:

Book2
	A	B
1	123 456-0001	\+11234560001
Sheet1

Cell Formulas
Range	Formula
B1	B1	=INT(SUBSTITUTE(SUBSTITUTE(A1,"-","")," ",""))

You can either prepend the "\+1" or number format adding "\+1" (what I did here).
Whether this is the "best" way probably depends on factors that are not outlined here - e.g. I have presumed that the 123 456-0001 is text and not a representation presented by a formula, etc.

Thank you!! This was really helpful.