Prev: Your entry cannot be used. An integer or decimal number may be req
Next: Excel 2002: Can I not overwriting non blank destination cells ?
From: da on 12 Mar 2010 18:27
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
From: Fred Smith on 12 Mar 2010 18:29
It depends on whether you have numbers or text.

If text, use:
=a1&b1

If numbers, use:
=a1*1000+b1

Regards,
Fred

"da" <da(a)discussions.microsoft.com> wrote in message
news:871FDE48-2AA0-4320-833F-3FA9E11EF1CE(a)microsoft.com...
> 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

 | 
Pages: 1
Prev: Your entry cannot be used. An integer or decimal number may be req
Next: Excel 2002: Can I not overwriting non blank destination cells ?