MS Excel – Is Null

To tell if a cell is Null use this code. The key being the brackets.

=IF(I2 <>"",I2,"")

MS Excel – Function to Remove Nonprintable Characters

Use this combination of Excel functions to scrub a cell of bad, MS Office and non-printing code

  • Substitute and CHAR(10) removes lines breaks
  • Clean removes all nonprinting characters

    • =LEFT(S2, LEN(S2) - 4)
    =IF(J3<0,CLEAN(SUBSTITUTE(J3,CHAR(10),", "))," ")

This entry was written by melrikswriter, posted on 02/12/2012 at 5:05 pm, filed under MS Excel and tagged , , . Bookmark the permalink. Follow any comments here with the RSS feed for this post. Both comments and trackbacks are currently closed.