CONCATENATE(text1,text2,....) function returns the value enclused by douoble qoutes on the left and right side of the value.
CONCATENATE("A","B") returns value "AB" in the cell. I want the value in cell like AB only.Can pls advice me.
ADAdministrator 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.