Hi,

I'm trying to find cells that contain a number and the letter A (such as "16A"), and replace them with just the number part (such as "16"). There are other cells that contain only letters (like "CAT") or only numbers (like "16") that I don't want to affect. Any advice would be appreciated.

Thanks!