So now I need to screen out not only stuff that's not empty, but stuff that doesn't have a space as the only content. I discovered this by clicking in the remaining seemingly empty cells, and yep, there was a blank space. That pesky EventBrite site puts in a space, just a single space, in some but not all of the empty lines. I made sure that the Name column was selected, left = selected, and selected Not Empty. It's a badly phrased option and has to do with whether you overwrite when pasting.Īnyway-so to remove the empty cells I selected the column and chose Data > Filter > Standard Filter. I want to have a nice singlespaced list of the names.īy the way, Edit > Paste Special, Skip Empty Cells, won't do what I want. But when I pasted the list to a spreadsheet, I got a bunch of blank cells.
The people signed up are listed on EventBrite, so since I wanted a list of people coming, I copied the list and pasted it into OpenOffice. I'm going to a big blues dance event this weekend. Delete those cells and you get the same result. It is a good solution for two or more columns, but if you have one column as shown here, the simplest approach is to just sort the column and the blanks and cells with one space in them will be grouped together. Note: As Karl pointed out in a comment, this is actually a complex solution.
0 kommentar(er)
