| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Groping
Hi,
suppose i have 2500 1 2 3 in cell a b c &d, how can i consolidate them to say 250123 or 250-1-2-3. please help |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Groping
=SUM(A1:D1) will sum it up
=A1&"-"&B1&"-"&C1&"-"&D1 will return the string If this post helps click Yes --------------- Jacob Skaria "Aha" wrote: Hi, suppose i have 2500 1 2 3 in cell a b c &d, how can i consolidate them to say 250123 or 250-1-2-3. please help |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Groping
You may use Concatenate function to combine all 4 values
OR =A1&B1&C1&D1 If this post helps click Yes --------------- Jacob Skaria "Aha" wrote: Hi, suppose i have 2500 1 2 3 in cell a b c &d, how can i consolidate them to say 250123 or 250-1-2-3. please help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
