Is it possible to get the length of a particular field. For example I would
like to copy the contents of an identification card, which has

- a number of numbers (n)
- ends with a letter which is usually M, L, A or something else :)

So basically I want to tell Excel to format the characters

From
nnnnn..A

where n is a number (0-9), A is an alphabetic character (A-Z), and,
the number of numeric characters in n... is unknown

I've tried playing about with the RIGHT functions but could not find any
functions for the "length of string" so I got stuck. Any ideas?