Excel Magic Trick 927: Insert Zero For Alphanumeric String With Single Digit Numbers

I am not able to find out the mismatch list which is having number leading with zeros and ending with text . How to match this list

How do I sort eg TRX4500, CXZ2541, PBX2311 by choosing last two digits

i love your videos! they have saved me time and grief on countless occasions! you are like the robin hood of Excel!  

I am glad that the video is helpful!

'Liked' the video. Was very helpful to me, thanks

You are welcome!

Thanks for posting all this tricks!!!

Thanks, krn14242!!

Thanks Mike, good tip.

I am glad that you enjoy them!

enjoy watching your videos

Since love amongst humans is THE most important thing in the world, that is great!! Thanks so much!

Great video!!!

Ok I don't want to sound gay, but I LOVE YOU man... you are awesome.

I am glad that you liked it!