SOLVED

Need Help with Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2318721%22%20slang%3D%22en-US%22%3ENeed%20Help%20with%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2318721%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20tried%20to%20combine%20two%20cells%20into%20one%20(first%20and%20last%20names)%20and%20i%20have%20used%20all%20the%20formulas%20that%20%22help%22%20suggested%2C%20but%20the%20formulas%20won't%20calculate.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2318721%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2318911%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20Help%20with%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2318911%22%20slang%3D%22en-US%22%3EHans%3CBR%20%2F%3EThanks%20for%20the%20quick%20reply.%20However%20-%20I%20have%20done%20all%20of%20that%20and%20the%20formula%20just%20doesn't%20calculate.%20All%20I%20get%20is%20the%20formula%20in%20the%20cell%20I%20want%20the%20results%20in.%3CBR%20%2F%3E%3CBR%20%2F%3EAny%20ideas%20on%20how%20to%20fix%20that%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2318797%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20Help%20with%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2318797%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1043983%22%20target%3D%22_blank%22%3E%40Kozlikm%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ELet's%20say%20you%20have%20a%20first%20name%20in%20A2%20and%20a%20last%20name%20in%20B2.%20Enter%20the%20following%20formula%20in%20C2%3A%3C%2FP%3E%0A%3CP%3E%3DA2%26amp%3B%22%20%22%26amp%3BB2%3C%2FP%3E%0A%3CP%3EThis%20can%20be%20filled%20down%20if%20necessary.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22S0366.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F277543iBAC521F118A3242D%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22S0366.png%22%20alt%3D%22S0366.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%E2%80%83%3C%2FP%3E%0A%3CP%3EP.S.%20If%20you%20prefer%20to%20combine%20the%20first%20and%20last%20names%20in%20the%20form%20%22Last%2C%20First%22%2C%20use%3C%2FP%3E%0A%3CP%3E%3DB2%26amp%3B%22%2C%20%22%26amp%3BA2%3C%2FP%3E%0A%3CP%3Einstead.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I have tried to combine two cells into one (first and last names) and i have used all the formulas that "help" suggested, but the formulas won't calculate.

 

What

4 Replies

@Kozlikm 

Let's say you have a first name in A2 and a last name in B2. Enter the following formula in C2:

=A2&" "&B2

This can be filled down if necessary.

S0366.png

P.S. If you prefer to combine the first and last names in the form "Last, First", use

=B2&", "&A2

instead.

Hans
Thanks for the quick reply. However - I have done all of that and the formula just doesn't calculate. All I get is the formula in the cell I want the results in.

Any ideas on how to fix that?
best response confirmed by allyreckerman (Microsoft)
Solution

@Kozlikm

Make sure that the cell you're entering the formula in is formatted as General, not as Text.

Also, check the Formulas tab of the ribbon. If the Show Formulas button in the Formula Evaluation group is highlighted, click it to turn it off.

You're a Genius!!
Cell was set to text not General!!
Thanks so much!!