| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Concatenate | Excel Worksheet Functions | |||
| Concatenate or not? | Excel Worksheet Functions | |||
| Concatenate help | Excel Worksheet Functions | |||
| CONCATENATE | Excel Worksheet Functions | |||
| I know how to concatenate ,can one de-concatenate to split date? | New Users to Excel | |||
Linear Mode
