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.