| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Adding with &
I use the following
In e1 i have the following: a1&b1&c1 a1 = 01 b1 = 1001 c1 = 05 In f1 I would like to use something like =e1+1, but only have 1 added to the b1 number. Is this possible? |
|
#2
|
|||
|
|||
|
one way:
=A1 & B1+1 & C1 In article , Jim wrote: I use the following In e1 i have the following: a1&b1&c1 a1 = 01 b1 = 1001 c1 = 05 In f1 I would like to use something like =e1+1, but only have 1 added to the b1 number. |
|
#3
|
|||
|
|||
|
Hi!
=A1 & B1+1 & C1 Biff -----Original Message----- I use the following In e1 i have the following: a1&b1&c1 a1 = 01 b1 = 1001 c1 = 05 In f1 I would like to use something like =e1+1, but only have 1 added to the b1 number. Is this possible? . |
|
#4
|
|||
|
|||
|
Or even:
=A1&text(b1+1,"0000")&c1 Jim wrote: I use the following In e1 i have the following: a1&b1&c1 a1 = 01 b1 = 1001 c1 = 05 In f1 I would like to use something like =e1+1, but only have 1 added to the b1 number. Is this possible? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add months and adding partial monhts | Excel Worksheet Functions | |||
| adding military time format | Excel Discussion (Misc queries) | |||
| adding hours and minutes | New Users to Excel | |||
| time format and adding tiome values. | Excel Worksheet Functions | |||
| Adding column data | Excel Worksheet Functions | |||
Hybrid Mode
