Bob789
07-23-2017, 01:20 PM
After running a macro with its final step to copy and then past everything as a value, the formula =IF(CELL("TYPE",E2)="B","",+E2) will evaluate to a blank cell when E2 was originally blank but the formula =IF(CELL("TYPE",K2)="B","",(VALUE(LEFT(K2,3)&MID(K2,5,3)&RIGHT(K2,4)))) when K2 was originally blank evaluates to a cell with an apostrophe. Does anyone know how to have this second formula evaluate to a blank cell without the apostrophe.