Excel Community Help Needed

[sumiyashajuti]

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]

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)

[#3]

@sumiyashajuti 

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