how do i delete dash in phone numbers

J

JoelS

How do I delete the dash in phone numbers using excel
Click to expand...

You could try "Control -H" and enter "-" on the first line (find what
you're looking to replace) and enter nothing on the second line (what
you'll replace it with) and then hit the 'replace all' button
 
S

Stefi

=SUBSTITUTE(A1,"-","")
or select range containing phone Numbers, Edit>Replace Text to find: -
Replace by: leave ir empty
Choose replace All

Regards,
Stefi


„scanzano†ezt írta:
 
P

Pete_UK

If the phone number is a real number and the dash has been put in by
formatting (i.e. it does not show in the formula bar), then you can
just change the format to General.

If the dash is incorporated within the phone number (visible in the
formula bar) then you could remove it in one operation using Edit/
Replace. Highlight the column, do CTRL-H, then Find dash, Replace with
nothing, and click Replace All. This will convert the number to a
proper number, so you will lose any leading zeros.

Another way would be by formula in a helper cell:

=SUBSTITUTE(A1,"-","")

and copy this down. This gives a text result, so leading zeros will be
retained.

Hope this helps.

Pete
 
Top