Combine two columns
 

Hi,

Is there a way to combine two columns, but inserting info from column "B"
only where "A" is blank.

I have column "A1- A300" & column "B1-B300", column A has some rows blank
now I would like to enter data from column B into A, where A is blank only.
I hope I made myself clear. Please respond

Thank you
--
smile

Combine two columns
 

Select column A, then use edit/go-to-special, select blanks. Then, assuming
the active cell is A4 (just look to see what it is), enter =B4 then press
ctrl/enter and just the blanks will pick up b's values. (If the active cell
were A12, you'd enter =B12 and ctrl/enter).
HTH
Bob Umlas
Excel MVP

"israel" wrote in message
...
Hi,

Is there a way to combine two columns, but inserting info from column "B"
only where "A" is blank.

I have column "A1- A300" & column "B1-B300", column A has some rows blank
now I would like to enter data from column B into A, where A is blank
only.
I hope I made myself clear. Please respond

Thank you
--
smile

Combine two columns
 

It worked great! Thank you
--
smile


"Bob Umlas" wrote:

Select column A, then use edit/go-to-special, select blanks. Then, assuming
the active cell is A4 (just look to see what it is), enter =B4 then press
ctrl/enter and just the blanks will pick up b's values. (If the active cell
were A12, you'd enter =B12 and ctrl/enter).
HTH
Bob Umlas
Excel MVP

"israel" wrote in message
...
Hi,

Is there a way to combine two columns, but inserting info from column "B"
only where "A" is blank.

I have column "A1- A300" & column "B1-B300", column A has some rows blank
now I would like to enter data from column B into A, where A is blank
only.
I hope I made myself clear. Please respond

Thank you
--
smile