Calculation to strip numbers from a field
I am keeping track of a lot of data formatted as follows: A001 B002 C001 XB002 XC300.
(It's rolls of film with the letters representing which camera exposed them. The X indicates 2nd unit photography).
IS there an easy calc or function that would eliminate the numbers and just give me the camera signifiers--e.g. Just the LETTERS from the field?
I suppose I could set up a substitute that knocks out every ordinal, but that seems a bit messy unless there's a way to say "Every ordinal."
Cheers and thanks in advance.