ExcelBanter - combine cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - combine cells (https://www.excelbanter.com/excel-discussion-misc-queries/258798-combine-cells.html)

combine cells

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

Fred Smith[_4_]

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

All times are GMT +1. The time now is 03:36 AM.