Excel formulas

%3CLINGO-SUB%20id%3D%22lingo-sub-2750255%22%20slang%3D%22en-US%22%3EExcel%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2750255%22%20slang%3D%22en-US%22%3E%3CP%3EMac%20os%26nbsp%3B%3C%2FP%3E%3CP%3ETried%20in%20excel%20for%20mac%202016%2C%3C%2FP%3E%3CP%3Eand%20tried%20ion%20office%20365%20web%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20combine%202%20cells%2C%3C%2FP%3E%3CP%3EI%20have%20tried%20%3Dconcatenate(a1%2C%20%22%20%22%20%2CB1)%20dint%20work%2C%3C%2FP%3E%3CP%3Etried%20%3DA1%26amp%3B%20%22%20%22%20%26amp%3Bb1%20didnt%20work%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2750255%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2750358%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2750358%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1155831%22%20target%3D%22_blank%22%3E%40Lonnie1025%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWhat%20do%20you%20mean%20exactly%20under%20%22%3CSPAN%3Edidnt%20work%22%20%3F%20You%20have%20an%20error%2C%20or%20unexpected%20result%20or%20what%3F%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Mac os 

Tried in excel for mac 2016,

and tried ion office 365 web

 

I am trying to combine 2 cells,

I have tried =concatenate(a1, " " ,B1) dint work,

tried =A1& " " &b1 didnt work

 

 

3 Replies

@Lonnie1025 

What do you mean exactly under "didnt work" ? You have an error, or unexpected result or what?

=concatenate(a1, " " ,B1) this shows up in cell c1, not the combine names

@Lonnie1025 

Change the number format of C1 to General. Press F2 and ENTER.