E
evoxfan
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.
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.