I had a spreadsheet recently (actually a CSV file which contained numerous columns of data. The values in the cells were either blank (empty) or the letter 'Y'. I needed to change all the blanks to 'N'. Find and replace didn't work as you can't specify blank as a matching character (at least I couldn't find out how, please comment if you know!) and I didn't have the energy or time to manually update each cell. After some research I found that the answer was the 'Goto -> Special' options hidden within the 'Edit' menu. Here's how to do it... Select the columns and/or cells that you want to perform the special find within (hold down CTRL as you click the column headers or individual cells. Click the 'Edit' menu and select 'Go To...': Then click the 'Special...' button: Then click the 'Blanks' option and click 'OK': Any cells within your selection that contain blanks will now be selected leav
eng mgr / leader / full stack / java / agile / tdd / security / aws / go