IF formula to only apply to STRING values

[Goldeyrien]

Hi Community,

I have a data input field that is sometimes a string value (e.g. "€ 260.34") and sometimes a numeric value (e.g. "260.34") which makes it problematic as I need to sum the balances.

When it's a string value I was able to successfully use a REGEX_REPLACE function to strip out the preceding currency symbol and white space before the number but when it the field is a number it throws an error.

Is there a way to apply an IF formula to only apply the REGEX_REPLACE function if the field is a string value and to skip if it is a numeric value?

Of course, I am open to any other solution you may suggest.  Thank you.

[Qiu · Accepted solution]

@Goldeyrien 
I think we can use the RegMatch for the purpose there.

Or we can use the Find and Replace tool with pre-defined currency table.

[Goldeyrien]

Fantastic.  Thank you Qiu!