ExcelBanter - Concatenate

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Concatenate (https://www.excelbanter.com/excel-worksheet-functions/225665-concatenate.html)

Mac8128

Concatenate

How can I concatenate three cells each with a number so that the concatenated
cell is a number, not text?

Example
A1 B1 C1 D1 (concatenated)
19 21 133 1921133

Storm

Concatenate

Try this:

=TEXT(A1&B1&C1,"*,***,**0,000")

"Mac8128" wrote:

How can I concatenate three cells each with a number so that the concatenated
cell is a number, not text?

Example
A1 B1 C1 D1 (concatenated)
19 21 133 1921133

David Biddulph[_2_]

Concatenate

=--(A1&B1&C1)
--
David Biddulph

Mac8128 wrote:
How can I concatenate three cells each with a number so that the
concatenated cell is a number, not text?

Example
A1 B1 C1 D1 (concatenated)
19 21 133 1921133

Gord Dibben

Concatenate

=(A1&B1&C1)*1

Gord Dibben MS Excel MVP

On Thu, 26 Mar 2009 11:50:01 -0700, Mac8128
wrote:

How can I concatenate three cells each with a number so that the concatenated
cell is a number, not text?

Example
A1 B1 C1 D1 (concatenated)
19 21 133 1921133

All times are GMT +1. The time now is 05:30 AM.