|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 12th, 2009, 06:05 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
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 
|
|
#2
August 12th, 2009, 06:44 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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
|
|
#3
August 12th, 2009, 10:47 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
