How do I replace numeric values only?

When using the replace rule in Excel, you can use "?" to represent a standard variable, e.g. if you had the text "Bottle 100g", and you set the replace rule as "????g", it would delete the "g" and the four characters before it, leaving you with "Bottle".

However, if I have lots of replace rules to make in a file, and I only want to eliminate the numerical values before a letter, how do I go about doing this?

For example, if I had the text "Dog food 10g", and I made a replace rule "??g", it would leave me with " food ". What I would really need, is a way of taking away the numeric values before the "g", which would give me "Dog food".

Therefore, is there a unique identifier for numeric and/or text values?

Or can you suggest an alternative method?

Thanks

@ Rahul - I'm not sure how that would work?

@ Oldchippy - This works for eliminating the last string if it is always like this, however it doesn't resolve the problem, as what happens if I have the following text values:

Dog Food 10g
Cat food 100ml
Dog Food 10g Special Offer

Your formula would give me the following results:

Dog Food
Cat food
Dog Food 10g Special

Meaning that it would delete the "ml" unit value and not exclude the "10g" from the last value (but you did point this out in your comment already).

From the 3 example values, I would like to have the following results:

Dog Food
Cat food 100ml
Dog Food Special Offer

so now it changes, you want to keep some numbers not others! only deleting those that are g not ml , is that correct?

@ martindwilson

Nothing has changed from the original request, which was to find a variable for numeric values in the replace function. So, where "?" represents both text and numeric values, I wanted to find something that could represent just a numerical value.

But, in answer to your question, yes, I would need to define which letter comes after the numbers for the replace rule. So, in this example, I want all instances where there is a number followed by "g" to be eliminated.

@ Rahul

Thanks, I'll take a look.

Hi Martin,

Thanks a lot for this, it works, this will help me a great deal!