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