I have written an excel function like below:
="WHEN mynumber >= '" & D65 & "' AND mynumber <= '" & E65 & "' THEN '" & A65 & " " & B65 & " " & C65 & "'"
The above mostly works the way I want. But if there value of C33 is null, it ends in an empty blank character at the end of the calculated value.
Could you suggest how I could get rid of the empty character. I trid TRIM function but could not make that work.
Thanks a lot.