name additions

[lorenzoc]

Hey everyone,

I am having troubling articulating what I would like to do. I have a series of numbers that are all different but I would like to add the same things to all of them. Here is the example:the original well name is 00/06-02-072-21W4/0 I would like a formula that would add a 1 to the begining of the name and a 0 in the second last part of the name to get us to this 100/06-02-072-21W4/00. I need to do this for a bunch of wells but the formula should be the same because I need to add the 1 and 0 everytime and in the same place.


thanks so much,

Lorenzo

 

[Special-K99]

="1"&A1&"0"
where A1 is the code

 

[lorenzoc]

="1"&A1&"0"
where A1 is the code

thanks so much... how about if I want that 0 to be the second last digit in the string

[TABLE="width: 283"]
<tbody>[TR]
[TD]00/15-18-073-21W4/2 and change this to 100/15-18-073-21W4/02

thanks,

Lorenzo[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]