formula to link words from 2 cells together

[mingali]

Hi,

I have two cells with words and would like to link it together in a new cell. May i know which formula can be used for this?

Thanks

[johncena]

as a example if u want to combine cell A1 & B1 then try below formula in cell C1.using "&" u can combine any text in excel.

Please Login or Register  to view this content.

[mingali]

Thanks. I used ="A1"&"B1" and it did not work. Now i know why.