May 18, 2012 #1 S Stoly Supreme [H]ardness Joined Jul 26, 2005 Messages 6,706 I want to replace te contents of a column with another column if the cells in the 1st column are empty.
I want to replace te contents of a column with another column if the cells in the 1st column are empty.
May 19, 2012 #2 S shekkery n00b Joined Jan 5, 2010 Messages 51 =IF(ISBLANK(B1)=TRUE,C1,B1) Replace as needed
May 20, 2012 #4 tim_m i'm so nice Joined Feb 10, 2003 Messages 5,539 just to be nitpicky you don't need the =TRUE part right? =IF(ISBLANK(B1), C1, B1)