Hi!

I have a small problem and i haven't got a clue how to solve it. Since you guys have helped me many times in the past, i figured that i might aswell ask you again. Here goes!

I want to move tags from one spreadsheet to another and in the process change their names.

I have 3 different tag names:
ME3440-05
HE3470-04
HE3490-05

Is there a quick & easy way to convert these tag names to 3440, 3470 & 3490 without using a case structure ?

Thanks !


Oooh! a bonus question ! When comparing 2 tagnames or serial no., how do i do the comparison ignoring if the letters are upper or lower case ?