I had mixed text so used the Lower( ) formula to make text consistent and
when copied the values only over it hid text in column A. So, I have cutoff
text in column A such as below, and I do not want to expand the column.
Column A contains the main categories and B has the sub sections.

PIPED UTIL
mickey fittings
minnie fittings

BUILDING D
perimeter wall
green house


I can go to each blank cell in Column B, hit delete, enter, and that works.
But I have over 1,000 lines.
Is there a better way to fix this?

Thanks in advance for your solutions.

I filtered by all blanks, hit delete, removed filter, and problem solved.

"evoxfan" wrote:

I had mixed text so used the Lower( ) formula to make text consistent and
when copied the values only over it hid text in column A. So, I have cutoff
text in column A such as below, and I do not want to expand the column.
Column A contains the main categories and B has the sub sections.

PIPED UTIL
mickey fittings
minnie fittings

BUILDING D
perimeter wall
green house


I can go to each blank cell in Column B, hit delete, enter, and that works.
But I have over 1,000 lines.
Is there a better way to fix this?

Thanks in advance for your solutions.