Need conversion for digits 0-9

[Jack-P-Winner]

I want to be able to put a group of numbers in a column/row and have them convert to what is called mirrors. Mirrors work like this here:


0 = 5
1 = 6
2 = 7
3 = 8
4 = 9

Please see attached and once again thank you so much gurus. y'all are the BEST!!!!!

 

[Hui]

=IF(LEN(H2)=1,RIGHT(H2+5,1),RIGHT(LEFT(H2,1)+5,1)&RIGHT(RIGHT(H2,1)+5,1))
Copy across/down

 

[Jack-P-Winner]

Thanks Hui, I can't wait to try this. I am going to have to buy you the whole yacht to go along with that life preserver. You are such a life saver

 

[Hui]

You may want to try:
=IF(LEN(H2)=1,RIGHT(H2+5,1),IF(RIGHT(LEFT(H2,1)+5,1)="0","",RIGHT(LEFT(H2,1)+5,1))&RIGHT(RIGHT(H2,1)+5,1))
which removes the leading zeroes

 

[Jack-P-Winner]

Beautiful Hui!!! THANK YOU SO MUCH!!!!

 

[Jack-P-Winner]

Hui,

Do you mind explaining to me how this code works? I mean I m trying to figure out how to write some of this stuff and it doesn't make sense how this works lol. How does =IF (LEN(H2)=1 and so on change a 0 to a 5? And so on .... I hope my question makes sense. If there is a learning tutorial that explains it better that's cool I just can't grasp things that don't make sense lol