IF formula to only apply to STRING values
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Fantastic. Thank you Qiu!
