I tried this and the blank cells now have #NA in them. When I chart that it
stills leaves a gap between two columns on my chart.

"Roger Govier" wrote:

Hi

For the chart use NA() instead of blanks

So, for your copy
=IF(Sheet1!A1="",NA(),Sheet1!A1)
--
Regards
Roger Govier

Ed wrote:
How do I skip a blank cell? I have a column of dates (Col A) and a column of
numbers (Col C). Col C has irregular blanks. I want to copy these to another
spreadsheet without the blanks in Col C and without the corresponding dates
in Col A. My purpose is to creat a column chart without the gaps caused by
blank cells. The IF function will return a blank for a blank but I want to
skip the blank.
.