For example, cell "A1=d 123-c\ 54.348xD c541"
The result I need is "B1=12354348541"
Now I'm use with SUBSTITUTE function like B1=SUBSTITUTE(A1,"-","") but is not very good
Thank you
For example, cell "A1=d 123-c\ 54.348xD c541"
The result I need is "B1=12354348541"
Now I'm use with SUBSTITUTE function like B1=SUBSTITUTE(A1,"-","") but is not very good
Thank you
With
A1: d 123-c\ 54.348xD c541
Try this:
First, create a Named Formula....
From the Excel Main Menu: <insert><name><define>
This ARRAY FORMULA (committed with CTRL+SHIFT+ENTER, instead of just ENTER) removes ALL non-numerics from a stringPlease Login or Register to view this content.
In the example, the formula returns: 12354348541Please Login or Register to view this content.
NOTE: That formula can only return Excel's limit of 15 digits.
(Credit goes to Harlan Grove for that solution)
How to combining in one cell more than one SUBSTITUTE function ? like
B1=SUBSTITUTE(A1,"-","") and =SUBSTITUTE(A1,"(","") and =SUBSTITUTE(A1,".","")
Well, to combine the formulas in your example.....
Try this:
Does that help?Please Login or Register to view this content.
Thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks