Assuming aaa- is in B1 then try:
=B1&A1

Hope this helps
Rowan

koba wrote:
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