Deleting anything that's not a Letter

[Derekreation]

Hi everyone, so my problem simplified is this: A1 is a super long column, say 50,000 rows, each cell will be filled with something like these:

A) "000001-ABC_DEF_Jumpstart All_Black Cat_AS_30x25" or "0001313_LALATV_FAE_LALALAKDAKFAKJFLAF"
B) "000004BED_ZHD_somethingfkjsahfkjhsakfjaksf"
C) "HPE_IEA_kjshfakjhgfkjashgkaksjgh"

What I need to do is get rid of the beginning sequence if it's not a letter (number, symbols anything else = bad).

So in A), I need it to be "ABC_DEF_Jumpstart All_Black Cat_AS_30x25" or "LALATV_FAE_LALALAKDAKFAKJFLAF". In B) I need it to be "BED_ZHD_somethingfkjsahfkjhsakfjaksf", C) would be untouched as "HPE_IEA_kjshfakjhgfkjashgkaksjgh"

Thank you in advance for helping guys!

[xladept]

Hi Derekreation,

Here's a String Stripper and a UDF

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[Derekreation]

Thank you XLAdept!!

[xladept]

Hi Derekreation,

You're welcome.