Concat is another way

[Pete]

I did not know the ampersand worked that way--pretty cool-
-I've always done this with the concatenate function,
which in this case would be

=concatenate("1",A1)

Regards,
Peter

 

[Pete]

Sorry I posted the above as a new msg--should have been a
reply!

 

[Peo Sjoblom]

I have a hard time even remembering the word concatenate so I rather use the
ampersand instead )

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)