I received a spreadsheet with contractor names in column A and contract #’s in column B. I want to concatenate the cells from columns A & B into column C so that both pieces of information appear in one cell.
The data in both columns A and B vary in lengh.
Here’s the puzzle: I want the cells to wrap so that the contractor name appears in the top of the cell and the contract number appears below it.
I could manually go into each cell of column C, position the cursor between the two pieces of information and press ALT + ENTER to obtain the desired result.
There are hundreds of entries on this spreadsheet, and I’d like to know if there is a way for a formula to do this for me.
The existing formula looks like:
=A1&” “&B1
What would I need to type after the quotation marks to make the data data in B1 appear on the next line within the same cell (C1)?
I’m using Excel 2003.
