how do i delete dash in phone numbers

J

JoelS

How do I delete the dash in phone numbers using excel

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top