Formula to Remove or delete the last word in a excel cell

Hi in this video we are going to learn to remove the last word from the Excel cell. Yes, basically, many mullahs that you can use to remove the last word flow or itself, but most of them aren't working very well and may or may not, but perfectly some formulas just keep some tax character from the last word as well. But the formula that I'm going to show you in this video is working perfectly that you can use.

I will also provide you the same formula right in the description so that you can copy it and paste it in you access it, because this formula is bit land here. So if I next screen, I would like to show you is my excel sheet. So friends, I am in my AK and this is the data that I want to remove the last word from these cells and it shall have some data text data and I want to remove the last word from each cell using a formula and a formula.

I want to use is this: this is quite a big formula, so I'm what I am doing, I'm just giving you this formula right in the description show that you can copy it and paste it. You know excel seat. I just remove the equals in from here. So that I can show you the formula right, otherwise it won't be showing you in excel sheet. So what we'll do we'll copy and paste it from the formula right in the column B? So we can get the desired result and and to dissolve the text in without the last word. Okay, so, let's see opens. I have already copied the formula my book, I'm going to paste it here right in the brief one cell and soon I paste it here.

It just move the last word from you fun. Okay, I can do the same. Just drag the formula till the cell. We want and heavier. It removes the last word from each cell. So friends, this is the formula that you can use in your Excel C.

If you want to remove last word from the text screen that you may have okay, let's see if we want to add something else here, what will happen? Okay, so it automatically be removing the last word from just texting. Okay, so friends, I hope you liked the video thanks for watching and please don't forget, to subscribe, my channel, so we are motivated to create new and more videos on Excel thanks for watching again

[joelluisa]

Thank you so much, big answer to my problem....