Hello all,

I have two questions....


1. How do I search for leading zeros in cells? I know I can do find and put a space, but that will look for anything with a space.

For example, lets look at the following items...and lets assume "_" represents a space
_apples
pumpkin_pie
_Orange_juice_
_pears

What I want is, to search for only items with leading zeros, so to pull up apples, orange juice and pears. I dont want to find pumpkin pie. What ever formula works is fine with me

2. How do I only right trim, nothing else.

example...
Orange_Juice_

I want it to be just Orange_Juice