What do you mean by "below 10001"? Row 10001? The values in your cells?

Also, B2&""&B3&""&B4&"" can be shortened to B2&B3&B4

--
Regards,
Fred


"Lisa" wrote in message
...
I need a formula that would concatenate only the blank cells between two
rows that have data. If the line below 10001 is blank (A3), concatenate all
the rows in B whose A value is blank.
I am using this formula =IF(A3="",B2&""&B3&""&B4&"",B2)
The problem is that sometimes, I might have two or more blank cells below
10001.
Could someone help!

Thanks!