I'm sorry, Lisa, you've completely lost me.

When you say "it breaks the column into more rows", what is "it"? Is your cell
formatted to wrap text?

I don't see any blank rows in Column A. Do you mean blank rows in columns other
than A?

You say "any row that would have more or less than 3 blank rows in column A". A
row can't have any more than one row. How can a row possibly have "3 blank rows
in Column A"?

--
Regards,
Fred


"Lisa" wrote in message
...
Fred,
It is a software problem, because if a column has more than 12 characters it
breaks the column into more rows and it looks something like this when I
apply the formula below. The problem is row A4 (10002), or any row that would
have more or less than 3 blank rows in column A.

Actual Output
A B Result
10001 Need Need Your Help
Your
Help
10002 Thank Thank You Regards
You
10003 Regards



"Fred Smith" wrote:

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!