Hi all,
Ive got a small problem that maybe someone can help me with. Ive got a number of codes in separate cells such as:
A02B xxxxxxxxxx
A10B bbbbbbbbbb
C09X hhhhhhhhh
What id like to do is remove the zeros if there is a zero placed in the second character of the code. i.e A02B xxxxxxxxxx will become A2b xxxxxxxxxx. How would i do this.I imagine its an IF function but im not sure how to put it together to specify the second character.
Many Thanks
Ive got a small problem that maybe someone can help me with. Ive got a number of codes in separate cells such as:
A02B xxxxxxxxxx
A10B bbbbbbbbbb
C09X hhhhhhhhh
What id like to do is remove the zeros if there is a zero placed in the second character of the code. i.e A02B xxxxxxxxxx will become A2b xxxxxxxxxx. How would i do this.I imagine its an IF function but im not sure how to put it together to specify the second character.
Many Thanks