View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kiannie Kiannie is offline
external usenet poster
 
Posts: 3
Default Adding text or number?

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 ?