Adding text or number?

[Kiannie]

How to add these ?

1) 0XXXXX + 100 = 0XXXXXX,
Note: X = numbers, Zero in the front must remain and i need to repeat this
for 1000 rows with all different values for all.
This mean :
0134000 >0134100
0123000 >0123100
0924820 > 092920

2) street 27
street 28
street 29

i want to add Road A at the back of each rows, means
street 27 Road A
street 28 Road A
street 29 Road A

What is the formula ?

 

[Gary''s Student]

1. put 100 in an un-used cell
2. copy the cell
3. select the cells you want to increment
4. Edit > PasteSpecial > Add
5. re-select the same cells you just incremented
6. Format > Cells... > Number > Custom > 0000000

the last step restores the leading zero.

 

[Gord Dibben]

=A1 & " Road A" entered in B1

Double-click on fill handle of B1 to copy down.


Gord Dibben MS Excel MVP