writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 51:
Line 51: +
no edit summary
=RIGHT(A2,8) : Displays last 8 characters in a string from cell A2. Displays '''HN SMITH''' as the output. Space Character is also counted.
=RIGHT(A2,8) : Displays last 8 characters in a string from cell A2. Displays '''HN SMITH''' as the output. Space Character is also counted.
=RIGHT(A3,9) : Displays all characters in a string from cell A3. Displays '''123*123''' as the output.
=RIGHT(A3,9) : Displays all characters in a string from cell A3. Displays '''123*123''' as the output.
=RIGHTB(A3) : Displays last character in a string from cell A3. Displays '''3''' as the output.
=RIGHT("Good Morning",7) :Displays '''Morning''' as the output.
=RIGHT("Good Morning",7) :Displays '''Morning''' as the output.