Trim A Cell Only If It's 4 Characters Long

='[NFL Schedule.xlsx]2011'!$C$3

When the above cell reference is applied it will return a result that is either 3 characters long or 4. If the result is 4 characters long, how can I rewrite this formula to ignore the first character and only return the next 3?

For example: If the contents of C3 is @CAR the result returned will only be CAR.

Maybe something like this:

=IF('[Len(NFL Schedule.xlsx]2011'!$C$3)>3,Right('[NFL Schedule.xlsx]2011'!$C$3,3),'[NFL Schedule.xlsx]2011'!$C$3)

abousetta

You could probably even just use this:

=Right('[NFL Schedule.xlsx]2011'!$C$3,3)

without checking the length of the cell's contents.

abousetta