Скачать или смотреть Remove last character from string excel Number of Characters From End of Text String

No friends, first of all, I would like to welcome you all again in this video and in this video we will learn how to remove certain character from the last in Excel said. Let me take you to my excel sheet, where I can show you, and the formula we are going to use is not very tough. Let'S see how we can remove certain character, certain number of characters from X and cell phone. So friend this is my excel sheet.

I created just for this video. As you can see. I have few values here in column, a from a two five one, two, two three four and five. I have these text string here and I am going to remove four last four characters from each cell. So there is a formula to remove four characters, and just I need your attention here for this numeric last remaining value here this numerically, you can always change it with the number of four character you want to remove. Okay, put your friends: let's use this formula here, okay, I need to make it two because the data, a message, starts at a two. So last four characters of this e two is eight seven, four, five: four it removed and remain left. So you just keep and drag it here. It will remove four characters.

Likewise, if I want to remove only three character lets to director, then you just need to make changes accordingly. Then it will do that now. It removes only two character from the last. So I hope you liked the video and this formula is very easy. You can also copy the paste formula from the description in you see it and oh, if you want a you can always remember not a big formula here and again, I request you if you liked my video, please do subscribe and do check click on the bell. Icon, so that you can get notifications as soon as create videos on excel tips and tricks, thanks for watching