I need to merge columns A and B, but some cells are blank, so I can't
copy the formula down the 3rd column...it stops at the 1st blank

a1 Frank Smith
a2 blank
a3 blank
a4 Bill Jones

b2 blank
b2 sally
b3 billie
b4 blank

HELP?


--
roger_home
------------------------------------------------------------------------
roger_home's Profile: http://www.excelforum.com/member.php...o&userid=16434
View this thread: http://www.excelforum.com/showthread...hreadid=396618