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


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 07:48 AM UTC

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

Live Chat Icon For mobile
Up arrow icon