maybe by putting 2007 in quotes & defining it as text, that would
work..........

="2007" & "utah"

both in quotes & not in quotes works for me.
hope that helps
susan


On Oct 13, 1:36*pm, danafeldman
wrote:
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