Here's the formatted text:
To delete the first four characters in a cell, you can use the "RIGHT" function in Excel. Here's how to do it:
- Select the cell that contains the text you want to modify.
- In the formula bar at the top of the screen, type
Code:
=RIGHT(A1,LEN(A1)-4)
(without the quotes). - Press Enter.
This formula will remove the first four characters from the cell and display the remaining text. In this case, it will remove "MRS." from "MRS. Mary Johnson" and display "Mary Johnson" instead.
I hope that helps!