Hi All,
I need some guides and tips to Concatenate some texts and trim the "+" symbol based on condition. If A1=apple, A2=banana and A3=orange, to Concatenate all with "+" sign, I can simply use (A1)&""&"+"&" "&(A2)&""&"+"&" "&(A3) to make up apple + banana + orange. However, if I delete A3 orange, it returns as apple + banana + , how do I set a formula to trim the last "+" sign if there are only 2 texts? Same problem with only 1 text where it return wrongly as apple + + . Any help is greatly appreciated.
Bookmarks