Changing quantitative values into text (created separate text sheet which was melded with data sheet using IF formula into 3rd sheet that now includes 0 values as well as transformed text. Now I need to remove all zeros to sum columns into one text result. Need to make the zero removal automatic going forward. If there was a way to use IF formulas to substitute text for numbers without creating 0's for those columns that didn't have a corresponding number value, that would be ideal. Can you help?
Solved by K. B. in 15 mins