Thread: Adding with &
View Single Post
  #2   Report Post  
JE McGimpsey
 
Posts: n/a
Default

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.