use &

=A2&A3&A4...........

scott wrote:

how does the formula =a1+1 work for letters instead of numbers? I have in c2
the letter "a" and in c3 i want to add b..which is simple by typing "b"...but
if i need 10 or more letters in a2:a25 or a28, how does the formula work?

sorry for the confusion....and thanks for the help