Combining two cells

[Harvey12]

Hi All,

I have a list of serial numbers that are split into the first half and second half. Eg:

First half: 9813/
Seconds Half: 3200

Now I could easily go through these and type the second half on the end to create: 9813/3200. But since there is a list of around 10,000 of these, I'd rather not.

Is there a formula to combine these two cells, everything I have come across has struggled because of the '/', excel treats it as a division sign.

Can someone please assist.

Many thanks
Harvey

 

[Smitty]

You can use & to join the two values:

=A1&B1

It will be seen as text, so the / shouldn't be a problem.

HTH,

 

[Harvey12]

Wow that was fast.

Many thanks, worked first time! Probably been struggling with this for a good 30 mins! Life saver!!