Text Issues
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.
|