• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 114
  • Last Modified:

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 Pinkston
Matt Pinkston
1 Solution
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
Robberbaron (robr)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.
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.
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.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now