Amy has attended:
Excel Advanced course
Cut out spaces in a list
How do I select a list that has spaces in it and chop out all the spaces by moving the cells that have data up to the top to form a consolidated list, with spaces below?
RE: Cut out spaces in a list
Hello Amy
Thank you for your question.
If the cells with the spaces (blank cells, I assume), are in one of the columns in your list, then if you sort by that column in ascending order, the rows containing blank cells will move to the bottom of the list.
Does this help?
Kind regards
Amanda
RE: Cut out spaces in a list
Hi Amanda, thanks for your response.
That does work, yes, but what if I wanted to keep the list in the same order as previous, except for the blank cells. I know that there is a way to do this as our excel tutor showed us how. I think it is something to do with selecting and formatting?
RE: Cut out spaces in a list
Hi Amy
I see Stephen was your trainer - I've checked with him to find out about what he showed you, and he tells me you do the following:
1. Select the whole list first.
2. Go to Edit - Go To (or use F5).
3. Click Special...
4. Select Blanks.
5. Click OK.
6. Right-click on top of some of the selected cell.
7. Select Delete from the shortcut menu.
8. Select the appropriate Delete option; click OK.
I hope this was what you were after.
Kind regards
Amanda
