Replace Characters to Left of a String with Another String/Character

Hi

I have 2 cells containing the following text:

ZMT5 Eagle
ZMT5GMT6 Eagle

What I want to loop through each cell and write If statements such that if cell contains Eagle and number of characters in cell =10 (comfortable up until this point) then

(part I'm not sure how to write) replace the 2 characters starting 3 to left of Eagle with a 1 else replace the 2 characters starting 3 to the left and 7 to the left of Eagle with a 1.

So output from the loop would be as follows:

ZM1 Eagle
ZM1GM1 Eagle

If anyone could tell me how to handle the string replacement piece, it would be greatly appreciated.
Thanks

Will all the outputs be in the same format as showed ?

Hi Pepe

When you say format, what do you mean in this context?

4 char - space - text
or
8 char - space - text
?

Well that is the format of the data in the existing cells so technically the input pre code execution but yes, always same format.

You can ignore, managed to work it out. Thanks for your assistance.

Care to share your solution with the board?

Apologies for very late response.

Please Login or Register  to view this content.

Thanks for sharing