Go to Special > Blank
Hi guys,
I have been struggling with finding all blank cells in my data set so I can replace with #N/A. Whenever I go through the ‘go to special’ process and select ‘blank’, None of the blank cells are highlighted. How do I fix this? Thanks
Hi guys,I have been struggling with finding all blank cells in my data set so I can replace with #N/A. Whenever I go through the ‘go to special’ process and select ‘blank’, None of the blank cells are highlighted. How do I fix this? Thanks Read More