combine cells

D

da

Hi
I need to combine the following Columns A and B by using a formula. How can
I do it?
thanks
A B
81 007
88 012
88 014
89 019
result should be
81007
88012
88014
89019
 
F

Fred Smith

It depends on whether you have numbers or text.

If text, use:
=a1&b1

If numbers, use:
=a1*1000+b1

Regards,
Fred
 
Top