HELP with renaming file paths in excel

[noob2214]

Hi,
I have a list like this in excel. There are over 100,000 rows liked that

#0256002_188995_huge.jpg
#0256002_188996_huge.jpg
#0256002_188997_huge.jpg
#0256002_huge.jpg
#00288003_388999_huge.jpg
#00288003_389000_huge.jpg
#00288003_389001_huge.jpg
#00288003_huge.jpg
#000227004_389003_huge.jpg
#000227004_389004_huge.jpg
#000227004_389005_huge.jpg
#000227004_huge.jpg
#0457002_588995_huge.jpg
#0457002_588996_huge.jpg
#0457002_588997_huge.jpg
#0457002_588998_huge.jpg
#0457002_huge.jpg


And now I need to change it so it looks like this

#0256002_1_huge.jpg
#0256002_2_huge.jpg
#0256002_3_huge.jpg
#0256002_huge.jpg
#00288003_1_huge.jpg
#00288003_2_huge.jpg
#00288003_3_huge.jpg
#00288003_huge.jpg
#000227004_1_huge.jpg
#000227004_2_huge.jpg
#000227004_3_huge.jpg
#000227004_huge.jpg
#0457002_1_huge.jpg
#0457002_2_huge.jpg
#0457002_3_huge.jpg
#0457002_4_huge.jpg
#0457002_huge.jpg


Does anyone know how I could solve this?

Thanks in advance

[karedog]

Maybe :

Please Login or Register  to view this content.