Regular Expression Pattern All Letters In String

Hi all,

Using Excel 2013.

Trying to get the pattern to return all letters in a string
My test string is "asdf134!#@$adsf]"
My current pattern is "[a-zA-Z]*"
So the result should be "asdfadsf"
But my pattern stops when 1 is encountered so the output is "asdf"

How can I get the pattern to continue through the entire string?

thx
w

Sub:

Please Login or Register  to view this content.

Function

Please Login or Register  to view this content.

Hi goss,
try it

Please Login or Register  to view this content.

(I forgot the name link to the Regexp in the available references)

How about ...

Please Login or Register  to view this content.

Nilem / Shg,

Thanks.
Nice use of recursion - the function works great!

Do you know is there a class for letters only.
I've Google'd quite a bit haven't found anything.

thx
w

There's no recursion in those functions.

"[A-Za-z]" is the pattern for letters, or just "[A-Z]" if ignoring case.

I would combine nilems's late-binding approach (to avoid the need for a reference) with a static object variable for speed:

Please Login or Register  to view this content.

Thanks shg,

Now I understand.
I was trying to extract only letters
You are replacing if not a letter with nothing.

Genius, thanks!
w

You're welcome.