join columns, keep both values

  • Thread starter Thread starter FourPenny
  • Start date Start date
F

FourPenny

I have a multicolumn database with text entries. I want to join the
cells in Col. B with the cells in Col.C and keep all the text. For
instance, B3 may be "1N", C3 may be "4W". I want the combined column
to read "1N 4W". How do I do this?!? TNX.
 
I assume that the last part of the suggested entry, ie the arrow,
represents the result and is not part of the formula.
So the formula: What cell is it entered for? I mean, do I click on B3
so that it's entered for that cell? And do I have to enter the formula
(revised for the particular cells) for every entry under Cols B & C?
There are hundreds of them.
Sorry to be dense. Your help is greatly appreciated.
 
FourPenny said:
I assume that the last part of the suggested entry, ie the arrow
represents the result and is not part of the formula.
So the formula: What cell is it entered for? I mean, do I click on B
so that it's entered for that cell? And do I have to enter the formul
(revised for the particular cells) for every entry under Cols B & C?
There are hundreds of them.
Sorry to be dense. Your help is greatly appreciated.
Click to expand...

The formula suggested by Ola

=B3&\" \"&C

can be entered in, say, Cell D3. Assuming that you have entries up t
Cells B100 and C100, copy this formula until in D3 until you reac
Cell D100.

To do this (copying formula until D100),

1. go to cell D3 and position your cursor to the right bottom corner o
the cell
2. as soon as you see a crosshair (" + "), click your mouse (don'
release it)
3. drag down until you reach Cell D100
4. as soon as you reach Cell D100, release the mouse.

Hope this helps you out.

Regards
 
Back
Top