ExcelBanter - Adding with &

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Adding with & (https://www.excelbanter.com/excel-worksheet-functions/11530-adding.html)

Jim

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?

JE McGimpsey

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.

Biff

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?
.

Dave Peterson

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

All times are GMT +1. The time now is 12:01 AM.