Problem: Remove numbers from a string that has both numerals and words. e.g. you have a list of addresses and want to remove the numers to create just a list of roads.
If you are new to UDFs, they are easy to install and use. To install it, simply press ALT+F11 to go into the VB editor and, once there, click Insert/Module on its menu bar, then copy/paste the above code into the code window that just opened up. That's it.... you are done. You can now use NoDigits just like it was a built-in Excel function. For example, =NoDigits(A1)
Credit: Rick Rothstein. https://www.mrexcel.com/board/threads/remove-numeric-characters-in-a-string.682393/
<figure class=”“wp-block-image size-large””><img src=”“https://gisdriverslicence.files.wordpress.com/2020/09/remove-digits-macro.png?w=1024”” alt=”””” class=”“wp-image-168”” /></figure>