join columns, keep both values

**FourPenny** · 05-30-2005, 01:16 PM

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.

**olasa** · 05-30-2005, 01:38 PM

Try this:
=B3&" "&C3 -->"1N 4W"

Ola

**FourPenny** · 05-30-2005, 02:01 PM

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.

**BenjieLop** · 05-30-2005, 03:43 PM

Originally Posted by FourPenny

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.

The formula suggested by Ola

=B3&" "&C3

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

To do this (copying formula until D100),

1. go to cell D3 and position your cursor to the right bottom corner of the cell
2. as soon as you see a crosshair (" + "), click your mouse (don't 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.