ExcelBanter - Convert phone numbers with dashes in them to just numbers

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Convert phone numbers with dashes in them to just numbers (https://www.excelbanter.com/excel-discussion-misc-queries/95614-convert-phone-numbers-dashes-them-just-numbers.html)

J H

Convert phone numbers with dashes in them to just numbers

I281-333-3333 - How do I change it to 2813333333

Thanks. Jenny

Toppers

Convert phone numbers with dashes in them to just numbers

For 281-333-3333 -

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

For I281-333-3333 - (with prefix of I )

=TRIM(SUBSTITUTE(RIGHT(A1,(LEN(A1)-1)),"-",""))

HTH

"J H" wrote:

I281-333-3333 - How do I change it to 2813333333

Thanks. Jenny

Gord Dibben

Convert phone numbers with dashes in them to just numbers

Where did that I come from<g

Gotta get new eyes one of these days.

Gord
On Thu, 22 Jun 2006 20:46:01 -0700, Toppers
wrote:

For 281-333-3333 -

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

For I281-333-3333 - (with prefix of I )

=TRIM(SUBSTITUTE(RIGHT(A1,(LEN(A1)-1)),"-",""))

HTH

"J H" wrote:

I281-333-3333 - How do I change it to 2813333333

Thanks. Jenny

All times are GMT +1. The time now is 11:13 AM.