Hi
I have a row of 5 cells e.g
12345 67891 Blank 12345 Blank
I have roughly 50 lines of data, how can I remove the blanks and just return the cells with entries?
Thanks
Hi
I have a row of 5 cells e.g
12345 67891 Blank 12345 Blank
I have roughly 50 lines of data, how can I remove the blanks and just return the cells with entries?
Thanks
Can you explain more clearly/ Is the whole column blank?
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Why do you have blanks, is this by design or a fault in the setup?
try
Change column to suitePlease Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks