='[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.
Bookmarks