How to remove text before or after a specific character in Excel

While working with Microsoft Excel sheets, you might need to remove the first few characters, or last few characters, or both from the text. Removing the first few characters from a column of texts is useful when you need to remove titles (Eg. Dr., Lt.). Similarly, removing the last few characters could be useful while removing phone numbers after names.

This post will show you how to remove the first or last few characters or certain position characters from the text in Microsoft Excel. You will learn how to:

1] Remove the first few characters from a column of texts.

2] Remove the last few characters from a column of texts.

3] Remove both the first few & last few characters from a column of texts.

[zpepe]

This does not answer the question how to remove letters before or after a specific character as the title suggests. In my case how do I remove all characters before @

[vaishalithakur]

Thanks it's very very useful trick. Thanku so much

[michelleroberts]

Thank you so much, this was extremely helpful!

[GenXGamez]

You are Gods - thank you so much. Saved me at least two (2) days. Take my upvote.

[nathanvessels]

wondering if you can help with this. I have a list of a lot of accounts where they have three levels and my accounting team provides the data in one cell in this format (L1: L2: L3) with the L# representing the account name. I just want the L3 value. Do you know of a way to trim everything to the left of the second colon?

[AqeelsLifeLens]

How to do it for multiple columns with different texts?

[vatsalvyas]

What if we don't have specific char. Example - Testing-INT and testing-user-INT. We want to copy and paste all the values in another column before INT.

[FortyFramesMedia]

You did a video that doesn't actually match the title of the video!

[tightywhitey]

good vid but god damn dude the music at the beginning nearly made me shit my pants!