View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
danafeldman danafeldman is offline
external usenet poster
 
Posts: 3
Default function works on some sheets but not others

I'm trying to combine a number and word using the &. The formula bar says
=2007&"utah", and it's giving me a #value error. When I copy the cell and
paste it in the next tab, I get the result 2007utah, which is what I wanted.
I can't do anything to get it to work in the first tab though. Are there
some reasons it might work in one tab but not another?
--
danafeldman