We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

CONCATENATE(text1,text2,....)

Hi, CONCATENATE(text1,text2,....) function returns the value enclused by douoble qoutes on the left and right side of the value. example:- CONCATENATE("A","B") returns value "AB" in the cell. I want the value in cell like AB only.Can pls advice me. MALLIK

1 Reply

AD Administrator Syncfusion Team April 4, 2005 02:48 AM

You can swap out our Concatenate function with one of your own that strips off the quotes using engine,RemoveFunction and engine.AddFunction. Here is a sample. http://www.syncfusion.com/Support/user/uploads/swap_Concatenate_32967fe.zip

Loader.
Live Chat Icon For mobile
Up arrow icon