Excel Community Help Needed

%3CLINGO-SUB%20id%3D%22lingo-sub-2014591%22%20slang%3D%22en-US%22%3EExcel%20Community%20Help%20Needed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2014591%22%20slang%3D%22en-US%22%3E%3CP%3EA%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20B%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20C%3C%2FP%3E%3CP%3ERod%26nbsp%3B%20%26nbsp%3BCali%26nbsp%3B%20%26nbsp%3B%20A1%2BB1%3C%2FP%3E%3CP%3EPlus%26nbsp%3B%20%26nbsp%3BSan%26nbsp%3B%20%26nbsp%3BA2%2BB1%3C%2FP%3E%3CP%3EHere's%20What%20I%20Want%20to%20Do%20in%20Excel%2C%20Can%20Anyone%20Help%20Me%20to%20Find%20Out%20the%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fforums%2Fpostpage%2Fboard-id%2FExcelGeneral%2Fattachments-key%2F2a25f3d4-f410-4af9-8392-7868f569bb06%23%22%20target%3D%22_blank%22%3EFormulas%20and%20Functions%3C%2FA%3E%26nbsp%3BOr%20How%20I%20will%20Do%20This%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2014591%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2014675%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Community%20Help%20Needed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2014675%22%20slang%3D%22en-US%22%3E%3CP%3EIf%20your%20need%20is%20to%20concatenate%2Fjoin%20the%20contents%20in%20the%20indicated%20cells%2C%20you%20may%20use%20the%20TEXTJOIN%20function%3A%20-%3C%2FP%3E%3CP%3E%3DTEXTJOIN(%22%20%22%2CTRUE%2CA1%2CB1)%3C%2FP%3E%3CP%3E%3DTEXTJOIN(%22%20%22%2CTRUE%2CA2%2CB1)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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

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)

@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