What does the ! mean before a cell when transferring the cell contents to a different page?
J Juanita May 13, 2005 #1 What does the ! mean before a cell when transferring the cell contents to a different page?
D Dave Peterson May 13, 2005 #2 If it's in a string, it means it's a point of emphasis: =if(a1=1,"Get too work!","Please, continue to work.") if you see it a reference, it's excel's delimiter to separate the sheetname from the address: =sheet1!a1 or ='this is sheet 1"!a1 The formulas return the value from that sheet in cell A1.
If it's in a string, it means it's a point of emphasis: =if(a1=1,"Get too work!","Please, continue to work.") if you see it a reference, it's excel's delimiter to separate the sheetname from the address: =sheet1!a1 or ='this is sheet 1"!a1 The formulas return the value from that sheet in cell A1.
