Macro to Delete only Alpha Strings but not Alphanumeric or Numeric Strings in a Cell

Hi There,

I require a macro that will delete all the strings in a cell that consist only of Alpha characters.

E.g.
I have a list of data in column A as per below

1 x 123ABC Washing Machine
2 x 234BCD Dish Washer
3 x 345CDE Refrigerator

I would like to remove that data that only consists of all text, so that the above strings would look like below.

1 123ABC
2 234BCD
3 345CDE

Any assistance would be much appreciated.

Assuming the data in col.A

Please Login or Register  to view this content.

How about this function:

Please Login or Register  to view this content.

use it as any other function:

Formula:

Please Login or Register  to view this content.

Where you have range and delimiter (in your case space).
if no delimiter space will be default so

Formula:

Please Login or Register  to view this content.

will work too.