BatTodorFrequent Visitor8 years agoReplace values to null Hi, I want to replace all values in all selected columns to null. In general, main aim is to Fill down all cells with value, but at first need to clear all previous information. Is it possible? Best ...Show More
ramdas_01Regular Visitor1 year agoExtract First Character and enter 0 in the pop-up, that's all 😄Note: This is applicable on multiple columns as well.
ExcelKnutFrequent Visitor to ramdas_011 year ago@ ramdas_01 That worked perfectly! Exactly what I needed. Why does Transform>Extract>First Character>0 work? If you could, please explain.
Related contentReplace Values Null to Blank or Blank to NullReplace NULLReplace Errors values with Null valuesReplacing null values with blankReplace Null Values and If
