LinkBack URL
About LinkBacks
Is there a way to take out all characters that are not numbers. Example:
42/75C32 would need to be 427532
175-22.5X16 RDS would go to 17522516
Thanks for your help!
Is there a way to take out all characters that are not numbers. Example:
42/75C32 would need to be 427532
175-22.5X16 RDS would go to 17522516
Thanks for your help!
You can download a free addin from here: Morefunc and apply formula:
=REGEX.SUBSTITUTE(A1,"[^0-9]","")
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Another way using a UDF:
Paste this in the VB editor (ALT+F11, Insert|Module)
and then apply formula in workbook:
Please Login or Register to view this content.
confirmed with CTRL+SHIFT+ENTER not just ENTERPlease Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks