Forum Discussion
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?
2 Replies
Better if you indicate desired result, not a1+b1, since it's not clear what you'd like to receive. If combine texts from these two cells use & instead of +, i.e. =a1 & b1
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)
