Thanks very much.
"excelent" wrote in message
...
in this example u have 13106 in A1 and -MAUI in B1

Cells(1, 3) = Format(Cells(1, 1).Text, "000000") & Cells(1, 2)

result in B3 = 013106-MOUI