How to Remove First Character in Excel

What you will Learn:

How you can remove the first character in excel cells. This method works fine even if the first character is different character/text in each cell.

Example:

Before: 03Amazing Excel

After: Amazing Excel

In the above example, we removed first two character that is, 03 from the excel cell.

How to Remove First Character in Excel

1) Download our remove first character excel worksheet

2) In “A” Column we need to remove first two characters. That is, we want to remove 03, 04, etc. from A column cells.

 

excel remove first character

 

3) If you want to display the result in B column, then use the below formula to remove the first character from A1 cells and show the result in B1 cells.

 

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

 

In the above formula,

A1 is the cell which contains character/text/string in that first few characters needs to be removed.

2 is the number of character which you need to delete from the first few characters (right to left character needs to remove).

That’s it. Now you can see we removed the first string from A cells and displaying the final result in B cells.

Let us know in a comment if you have any other suggestion or any other method you prefer to remove the first character in excel apart from the above method.

Click Here to Leave a Comment Below 0 comments

Leave a Reply: