Hi!

Try this:

A1 = 6000
B1 = aaa

=B1&"-"&A1

Biff

"koba" wrote in message
...

Hi all

please help

i have a cell with a number such as 6000 (a1) and another cell with a
text aaa- and i would like to combine them in another cell to make
aaa-6000, could somebody please help me with a formula?

thanks
Andrew


--
koba
------------------------------------------------------------------------
koba's Profile:
http://www.excelforum.com/member.php...o&userid=28639
View this thread: http://www.excelforum.com/showthread...hreadid=492631