Yes, it is possible to use the MID function to pick the last three characters of a string from right to left. Here's how you can do it:
- Determine the length of the string using the function. For example, if the string is in cell A1, the formula would be:
- Subtract 2 from the length of the string to get the position of the third character from the end. For example, if the length of the string is 10, the position of the third character from the end would be 8.
- Use the function to extract the last three characters of the string. The formula would be:
Formula:
=MID(A1,LEN(A1)-2,3)
This formula tells Excel to start at the position of the third character from the end (
) and extract three characters (
) from that position.
So, for example, if the string in cell A1 is "Hello World", the formula would return "rld".