I have two cells A1 with value "A" and B1 with value "B".
How do i get cell B1 to end up with the value "AB",

I have tried concatanate but that need a third cell, are there any
other ways to do this...


gaz