How to Remove First 3 Characters from String in Excel

To remove the first three characters from a string in Excel, you can use the RIGHT and LEN functions. Here's how you can do it:

1. Open Excel and type the text you want to remove the first three characters from in cell A1. For example, let's use the text "HelloWorld".
2. In cell B1 or any other cell, enter the following formula:

=RIGHT(A1, LEN(A1) - 3)

3. Press Enter to apply the formula.

Example

Let's work with an example where we want to remove the first three characters from the text "HelloWorld":

1. Type "HelloWorld" in cell A1.
2. In cell B1, enter the formula:

=RIGHT(A1, LEN(A1) - 3)

3. Press Enter to apply the formula.
4. The resulting text in cell B1 will be "loWorld", as the first three characters "Hel" have been removed.