Hi all,
I have a data set that I would like to replace 0's with <1. However, this column includes numbers like 10, 20, 30, etc. so the replace formula is changing 10 to 1<1. Is there a formula that will look for isolated 0's?
Replace([Runway in years], "0", "<1")
Solved! Go to Solution.
@AMCM0806 some thing like this?
This was the simpler solution that worked. Thank you!