Hi. Im trying to concatenate cells snd only get the formula showing =A1&B1,
not the result. I looked through help, it says to cut and paste "only values"
but this option doesn't appear! (I get 6 options by clicking the arrow next
to the clipboard, only to do with format.) I tried special paste and selected
"values" but its not having any of it. What's going wrong? ANy help would be
great.
Thanks.