How to copy the last 9 characters from a cell
Hello,
I tried to find a formula on google
The cell contains any information like:
NUMBERS BLA BLA BLA - GHS1234/P
I need just last 9 characters. How can I formula this?
If the data is in, say, cell B2 then the formula would be:
=RIGHT(B2,9)
One handy place to get more help on formulas (explanations and many examples of how to use them) is at Help > Formulas and Functions Help in your menu.
SG