I want to merge two side by side colomns

[George]

I want to merge two colomons with text and numbers in them

 

[oldchippy]

Try

=A1&B

 

[Ashish Mathur]

Hi,

A2&B2 and copy down

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[lindyloo]

You can use the CONCATENATE function - this allows to you to join two text
strings together ie 6248 and 001 becomes 6248001