add text to cell

user3307 · May 31, 2007

how do I add the text in column A to the number in column B?
example:
A1: Spain
B1: 1098
=> Spain_1098

Many thanks!
Emma.

Mike H · May 31, 2007

Emma,

Try:-

=A1&"_"&B1

Mike

Joel · May 31, 2007

=CONCATENATE(A1,"_",TEXT(B1,"general"))

user3307 · May 31, 2007

thank you!

Mike H said:
Emma,

Try:-

=A1&"_"&B1

Mike