How to remove the first character of a cell in Excel

For example, you have the following the text in a cell “A1″ and you’d like to remove the first character “:

“I want to remove the first character of this cell

To remove the first character ” from A1, use one of the following formula:

=MID(A1,2,LEN(A1))

or

=REPLACE(A1,1,1,"")

or

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

The result:

I want to remove the first character of this cell

Not working for you?

Remember to replace A1 with the cell that contains the string of words you want to parse out.

This entry was posted in Extracting words. Bookmark the permalink. Post a comment or leave a trackback: Trackback URL.

Post a Comment

Your email is never published nor shared. Required fields are marked *

*
*

You may use these HTML tags and attributes <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>