CONCATENATE(text1,text2,....)

[mallikarjuna]

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

[Administrator]

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