Going to make another request on here for anyone who has done this…
I’m trying to look through characters in the records in one of my columns (it’s a combination of letters and numbers), and I’m trying to get rid of the letters so only numbers remain. For example, “I have 3 dogs” would get changed to “3”.
Tried doing something like the below, but no luck…
I tried the same thing with AND() and no luck either.
I know if I can do this, I’ll probably need to combine the result with TRIM() to get only the number value.
Has anyone done anything like this before?
To be transparent, I got this recommendation for a different column I was trying to create…
** FIND(‘black’, Text) > 0, **
** FIND(‘white’, Text) > 0, **
** FIND(‘brown’, Text) > 0, **
I get using the IF(FIND()) combination technically could work, but it would be pretty insane doing that for a large range of numbers (1 - 1000)