Display field less a character

[cvgalloway]

I have a field that is a string and the data reads like:

123A

56785A

12-5A

The first part of it varies on how many characters that it has but it will always end in the letter "A"

I want a formula that I can eliminate the A - I only want characters prior to A to display

Thanks for all your help!!

 

[Turkbear]

Hi,
Try

Left({Field},(Len({Field}) - 1))





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[cvgalloway]

Yep, that worked perfectly - Thanks!!