My thought is that this is a basic excel question, but can someone help me insert an IF IS BLANK statement into the formula below;
=VALUE(TRIM(CLEAN(G2)))
Thank you!
My thought is that this is a basic excel question, but can someone help me insert an IF IS BLANK statement into the formula below;
=VALUE(TRIM(CLEAN(G2)))
Thank you!
perhaps this... =IF(G2="","",VALUE(TRIM(CLEAN(G2))))
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Perfect! Thank you!
You're very welcome, AND thank you for the rep!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks