MrExcel Publishing
Your One Stop for Excel Tips & Solutions

simple problem with functions


Posted by steven on January 09, 2001 10:53 AM

why is it that when I write a function to simply copy the contents from one cell to another, it works for numbers but only displays the function in the cell when trying to do the same thing with text.


Posted by Mark W. on January 09, 2001 11:05 AM

Because you can't enter a formula (an expect it to
evaluate) into a cell that's already formatted as
text...


Posted by steven on January 09, 2001 11:26 AM

So what would suggest doing in order to copy the text of one cell in a worksheet to another cell in a different worksheet

Posted by Mark W. on January 09, 2001 11:32 AM

Paste Special... Values or Formulas

Posted by steven on January 09, 2001 11:42 AM

is that the same as linking cells

Posted by Mark W. on January 09, 2001 12:04 PM

No. Use Copy, Paste Special... All and
click the Paste Links button.

Posted by steven on January 09, 2001 12:09 PM

thanks