leaving only numbers in the cell

Hi.

I need to remove bars, dashes, commas, at once inside a cell.
Exemple:
----Original---------------Result
25.569.589/0001-68--25569589000168

i try ...don't work....# VALUE!

Please Login or Register  to view this content.

Formula:

Please Login or Register  to view this content.

array entered will get up to 15 digits
in 2007 or later this should also work again array entered

Formula:

Please Login or Register  to view this content.

in both cases format cell number no decimals
or even this udf

Please Login or Register  to view this content.

use as =numbers(A1)
all this learnt for here
http://www.mrexcel.com/forum/showthr...-not-clustered

Hi.
works perfect.
could explain the code?
thank you!

Originally Posted by marreco

Hi.
I need to remove bars, dashes, commas, at once inside a cell.
Exemple:
----Original---------------Result
25.569.589/0001-68--25569589000168
i try ...don't work....# VALUE!

you should change to that:

Please Login or Register  to view this content.