Formula to Increment Alphanumeric from negative to positive in "X" row sets

Hi All! I have a value "Y-9." that I need to incrementally increase by "2." up to a value of say "Y9." (I will do the same with an "X-20." to "X20." and I assume the same formulation would work for both)
I also need this increase to stay the same for approx. 10 rows.
Below is my Sample/TEST. The problem is "LEFT(A1,1)&TEXT(RIGHT(A1,3)+2,"0."" looks for the three right most digits. being "-9."........... When the value increases to a POSITIVE, it drops the "-" (NEGATIVE) and is now a positive "y9." This then fouls up my code, leaving me wanting more, and giving the #VALUE! .........…
Between my two columns, of X-20. to X20. and Y-9. to Y9. I have 220 ish COMBOS.

On a side note, every time y goes from Y-9. thru the range to Y9. I need X to increase by 2. …….. Which I can do with the code below if I figure it out. AND Also, I need Z to decrease by .15 every row. up to Z-1.5 ……… This I am pretty ok with copying and pasting, unless someone feels crafty.

This is my SAMPLE for the "Y" Column - using the following code:
=IF(COUNTIF($B$1:B1,B1)=3,LEFT(B1,1)&TEXT(RIGHT(B1,3)+2,"0."),B1)

B1 being y-9.

X-20. Y-9. Z-.15
X-20. Y-9. Z-.30
X-20. Y-9. Z-.45
X-20. Y-9. Z-.60
X-20. Y-9. Z-.75
X-20. Y-9. Z-.90
X-20. Y-9. Z-1.05
X-20. Y-9. Z-1.20
X-20. Y-9. Z-1.35
X-20. Y-9. Z-1.50
X-20. Y-7. Z-.15
X-20. Y-7. Z-.30
X-20. Y-7. Z-.45
X-20. Y-7. Z-.60
X-20. Y-7. Z-.75
X-20. Y-7. Z-.90
X-20. Y-7. Z-1.05
X-20. Y-7. Z-1.20
X-20. Y-7. Z-1.35
X-20. Y-7. Z-1.50
SKIPPING ROWS SKIPPING ROWS
X-20. Y9. Z-.15
X-20. Y9. Z-.30
X-20. Y9. Z-.45
X-20. Y9. Z-.60
X-20. Y9. Z-.75
X-20. Y9. Z-.90
X-20. Y9. Z-1.05
X-20. Y9. Z-1.20
X-20. Y9. Z-1.35
X-20. Y9. Z-1.50
X-18. Y-9. Z-.15
X-18. Y-9. Z-.30
X-18. Y-9. Z-.45
X-18. Y-9. Z-.60
X-18. Y-9. Z-.75
X-18. Y-9. Z-.90
X-18. Y-9. Z-1.05
X-18. Y-9. Z-1.20
X-18. Y-9. Z-1.35
X-18. Y-9. Z-1.50

Thanks for the quick response, although I'm not after the Isolated numbers as much as I am the compiled list.
Short story, CNC PROGRAMMING, trying to write a Peck Tapping cycle and I need the compiled LIST of X, Y, Z coordinates to copy and input in my "G-Code". The "STARTING POSITION" is (negative) X-20. Y-9. Z-.15 the ending position would be (positive) X20. Y9. Z-1.5
note that the XandY increment by 2. which is 2". These are my hole spacings! but there's 220 holes roughly, and 10depths of cut for each hole in .15" increments hence the z-.15 z-.30 etc..... you can see my delimma!

Ok, Makes sense, I feel as tho I could generate the numbers I need with that method, However I'm no pro, and I am not sure what "I1=--MID(F1,2,99)" is, could you explain briefly? I guess you could just as easily as I could google.... I would then need to add back the X for X values and Y for Y values...


EDIT, I think im catching on. but please explain if you get a chance!

Oh, ok, I am starting to see! I think I understand. I am stepping out for a bit, I will get after it later! I will respond either later today or tomorrow. thanks so much for your help!

Thanks FDibbins, If I manually enter Y Values in "G" The Z Formula works up until the Y value changes. Then the Z jumps. Id post pics, but Im not sure if the uploads are working. And when I place the Y code in the G2 slot, it just says the code. It doesn't formulate a number.

That looks like it! Thanks SO VERY MUCH! Man that was some fancy footwork.... That will be applicable in more than one instance for me. I don't come to Excel Forum often, but when I do you guys never disappoint! Thanks again! Happy Friday!

How do I now mark this post as solved?