Forum Discussion
sumiyashajuti
Dec 24, 2020Copper Contributor
Excel Community Help Needed
A B C Rod Cali A1+B1 Plus San A2+B1 Here's What I Want to Do in Excel, Can Anyone Help Me to Find Out the Formulas and Functions Or How I will Do This?
SaniGarba
Dec 24, 2020Brass Contributor
If your need is to concatenate/join the contents in the indicated cells, you may use the TEXTJOIN function: -
=TEXTJOIN(" ",TRUE,A1,B1)
=TEXTJOIN(" ",TRUE,A2,B1)