How to remove blank space?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a line chart from the data source that contains either blank
space or is null. I tried to remove blank space or cell has value is null
from this line chart but could not. Please help!

Thanks,

Daniel
 
Replace the empty cells by #N/A.
Either =IF(A1="",NA(),A1), or modify an existing formula appropriately.
 
Back
Top