Can I use Trim for a calculated column to accomplish this:

When Trx Id is 123456N make it 123456.

Also, when Trx ID is 123456I make it 123456.

In other words, remove any letters from the transaction ID.

Is this possible? What is the formula?

Please advise.

Wow.. I figured this out too. I used, Left(Trim({Trx Id}),6) and it worked! Amazing!! I love the Trim command!

Sorry I would delete these posts, but don't see that as an option anywhere.