Thread: combine cells
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith[_4_] Fred Smith[_4_] is offline
external usenet poster
 
Posts: 2,389
Default combine cells

It depends on whether you have numbers or text.

If text, use:
=a1&b1

If numbers, use:
=a1*1000+b1

Regards,
Fred

"da" wrote in message
...
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