Adding with &

[Guest]

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?

 

[JE McGimpsey]

one way:

=A1 & B1+1 & C1

 

[Biff]

Hi!

=A1 & B1+1 & C1

Biff

 

[Dave Peterson]

Or even:

=A1&text(b1+1,"0000")&c1

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?