Remove any letter from a referenced cell
Your welcome.
I noticed after you had included the space in your required output. If you
do want spaces output then change the pattern to
..Pattern = "[\d\-\&\?\"" ""]"
Mike
"FiluDlidu" wrote:
Thank you so much Mike!
I've been wondering for a few years now how to create a function in Excel
and cursing at the impossibility to use regular expressions.
You have way more than answered my question: you also showed me
possibilities I was eager to know but didn't know where to look for and how
to get started.
|