extracting numbers

[Guest]

I have a row of numbers like 444.334.2342 and I want to condense them down to
4443442342 to get rid of the "."

Any suggestions?

Thanks in advance.

 

[Guest]

Hi Trevor,
If all numbers are formatted as xxx.xxx.xxxx, format the data as text, and
then you can use this formula:
=LEFT(A2,3)&MID(A2,5,3)&RIGHT(A2,4),
Then just copy and replace values.

The advantage of using a formula like this, instead of just using a find and
replace, is that it will recognize leading zeroes, and keep them for you.
HTH

 

[Dave Peterson]

How about selecting your range and
edit|replace
what: . (dot)
with: (leave blank)

You'll end up with numbers and may have to format them to show any leading 0's.