Find & Replace using VBA

[Burrgogi]

In col. B, I have the following:
apples1.txt
apples2.txt
chartsa.jpg
chartsb.jpg
objects.jpg
travelagenda.txt


In col. C, I would like the following:
_layer1.txt
_layer2.txt
_layer1.jpg
_layer2.jpg
_layer.jpg
_layer.txt


So, I recorded a very simple macro

Find: *1.txt
Replace with: _layer1.txt

Find: *1.jpg
Replace with: _layer1.jpg

Find: *2.txt
Replace with: _layer2.txt

Find: *2.jpg
Replace with: _layer2.jpg

For whatever reason, the macro does NOT work. It only works 1/2 the time.
_____________________________________________________________________

The 2nd part of my problem is that in that in col. B, I have:
3425816_7928501.jpg

In col. C, I want:
_layer.jpg

I don't know of any find & replace method that will achieve this.

 

[Burrgogi]

Shoot, I can't edit my post, the time limit has expired.

=================== ***** REVISED POSTING ***** ===================
In col. B, I have the following:
apples1_hw.txt
apples2_hw.txt
chartsa_hw.jpg
chartsb_hw.jpg
chartsc_hw.jpg
cooler.jpg
toys.jpg
travelagenda_hw.txt


In col. C, I would like the following:
_layer1.txt
_layer2.txt
_layer1.jpg
_layer2.jpg
_layer.jpg
_layer.txt

Basically I want the macro to look at each element, does the element represent a series as in chartsa_hw; chartsb_hw; chartsc_hw...?(same example with "apples"). If so, then give me a output in col. C layer1, layer2, layer 3 etc....

So, I recorded a very simple macro

Find: *1_hw.txt
Replace with: _layer1.txt

Find: *1_hw.jpg
Replace with: _layer1.jpg

Find: *2_hw.txt
Replace with: _layer2.txt

Find: *2_hw.jpg
Replace with: _layer2.jpg

Problem is that if you look at travelagenda_hw.txt, the macro I recorded gives me an output of _layer1.jtxt because "travelagenda" ends with the letter 'a'.

And For whatever reason, the macro does NOT work if there is no such occurrence of examples like "travelagenda". Very odd. It only works 1/2 the time.
_________________________________________________________________

The 2nd part of my problem is that in that in col. B, I have:
3425816_7928501.jpg

In col. C, I want:
_layer.jpg

I don't know of any find & replace method that will achieve this.

 

[Peter_SSs]

I'm afraid it still isn't clear to me.

 

[Burrgogi]

Peter, could you just delete this thread? I'll make a new post and try to explain it better. I don't want to make yet another revision to this thread and make it convoluted.

 

[Peter_SSs]

We don't generally delete threads unless they contain spam or other inappropriate content. However, I have closed this thread so it cannot be added to. Proceed with your new thread.