combining columns

column B is last name
column C is first name
in colum D I wants last name, firstname

shouldnt =B1&", "&C1 work?

it does nothing
Matt PinkstonAsked:
Who is Participating?
 
Robberbaron (robr)Connect With a Mentor Commented:
try using spaces between the ampersand,

=B2 & ", " & C2

but it should work fine as you have entered, provided the cell is recalc ed .  ie the workbook is set to automatically recalc, or you manually do so,

make sure there is no 'Calc' symbol in bottom left. I occasionally have workbooks that revert to manual mode. Change from ribbon buttton, excel options, formulas,  Automatic.
0
 
n2fcCommented:
Works just fine!

Perhaps you can upload your spreadsheet to see why it doesn't work?

I attached a sample showing it DOES work!Book1.xlsx
0
 
terencinoCommented:
Also the cell might be formatted as Text.
Just format as General instead, hit F2 on the cell and Enter to see if it works now.
...Terry
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.