Delete cells that contain numbers

[MarkFltc]

I have a spreadsheet with cells containing names in some cells and codes which are combinations of letters and numbers and I need to clear all the cells that contain the codes so that I am left with only the cells containing names.

for example:

John Doe
A1234, B234
c234, T678
Jane Doe
F256, J987

And i want to be left with:
John Doe


Jane Doe


How can i do this in VBA.

Any help is appreciated.

[Trebor76]

Hi MarkFltc,

Welcome to the forum!!

Try this (firstly on a copy of your data as the results cannot be undone if they're not as expected):

Please Login or Register  to view this content.

This uses a nifty User Defined Function (UDF) created by jindon (refer url in code).

Regards,

Robert

[MarkFltc]

Thank you!

worked like a charm!

[Trebor76]

You're welcome. Thanks for marking the thread as solved