for example
A1 = " unit message is message 19 + (P_TGT_WFI_QTY – U_INFLIGHT_AMNT) + message 2"

A1 also Equals IF(AQ4="",AM4,IFERROR(MID(AM4,1,AR4),AM4))


So it is a formula not a plain text

How do I get rid of the space infront of the A1 ( " unit.....")


TRIM FUNCTION DOES NOT WORK