Highlight column B, then press the F5 key (GoTo). Click on the Special button at the bottom of the panel, then click against Blanks and then click OK. Then type n/a but instead of pressing the Enter key, hold down the CTRL key and then press Enter. All your blank cells will be filled with n/a. You can release the CTRL key.

Hope this helps.

Pete