Hello everyone,

I dont think this is possible but if someone can tell me for sure it would be much appreciated!

Ive got numbers in cell A eg. 10062

I have then got a dash & a letter in cell B eg. -H

Is there anyway that is not manual to join the two so they become 10062-H in a singel cell, with a view to apply it to hundeds of numbers?

Thanks

Jamie.c