Length / IF formula or formatting?

[krispartsbadger]

I use a scanner to enter DHL, FedEx, & UPS tracking numbers into a spread sheet, and unfortunately the scanner can not be reprogrammed. The scanner picks up DHL and UPS perfectly but FedEx scans an additional 22 numbers to the tracking. To clean it up I use the =Right(A1,LEN(A1)-22) formula, which works great.

Examples:
DHL:5525356833
UPS:1ZW1E4770329477584
FedEx: 1001901781540005309200762204514878

All shipments have a very similar number patterns.

I want to scan the tracking numbers from all 3 examples into the A column and get my intended tracking numbers in the B column. DHL and UPS data would stay the same and I would need to use the formula mentioned above to get the intended outcome for the FedEx trackings.

Is there a formula or certain conditional formatting that will work for what I am trying to accomplish?

[dosydos]

you could just throw an IFERROR() in the front of your formula:

=IFERROR(RIGHT(A1,LEN(A1)-22),A1)

[etaf]

how many characters in total on the FedEx info
you could use LEN()
if it adds

an additional 22 numbers

in B1
=IF( Len(A1)>22 , Right(A1,LEN(A1)-22) , A1 )
and copy down