query to extract last words from sentence

Key Takeaways

hi friends this is rajinikanth Excel Guru and here I'm going to explain you this is actually one quiz that could be one of our great person that is I call him Juliet Bill Gates and his name is Anand so he wants to know how to extract last word from this only the last word like this okay you want to extract only the last word okay did you understand what I mean to say you want to extract only the last word here number of things are different here the values are differencing okay so how you can accept only the last word without using Flash Fill all those things right now before starting this I request everyone to like share and subscribe and send this to everyone so that everyone should get a knowledge of this okay now I am going to explain you how to extract a last word from these sentences first of all you have to know what is the last space over here the last space over here so how you will do this one so you do what you will do you just count how many spaces over there so you will get automatically the last space see one two three so you have to count how many spaces are there so I will length function minus length of substitute the text is this one the A3 comma old text is space and new text is blank that's it okay so it will count how many the total spaces so automatically we'll get the last space okay forgot to keep this one bracket see one two three one two three here see you are double click okay one two three four five six seven eight so this is the last space okay did you understand what I mean to say now so what you will do you insert uh you insert a new character here you have to insert a new character in that third space okay in that in that place which is not available in the sentences which is not available over here in this any of these values so what you will do here substitute of this old text Place comma the new text the new character which is not available in the value the carrot or Ampersand you can take this one easily you can understand this one and the instance instance means be interacting with a current that is second or third or fourth or fifth so I accept this one foreign value so I'll close this one and enter see you will find the here one two three here you can find the ampersand so now you have to remove the Ampersand by searching of search of ampersand comma in this value so it will pick up this position where it is it will go directly over here until enter double click if you will do director if you look at direct experience over here it will become one two three fourth because into the first occurrence of the value and check space comma in this if one two four five six it will pick up this fifth current of this page okay so for that reason you have to insert a new character in that position where it is space your country will get the 14th Place okay so what a right will not uh that will not work over here so you have to little bit uh what your same logic so here you have to use a replace function replace of old text starting from which characters starting from one how many number of characters you want to extract you want to remove I want to I mean to say you want to replace 14 characters till you find a person till you find Ampersand remove whole thing searching from one so close parenthesis the new text is parenthesis and enters here is the magic got it and if you have any more doubt let me know in the comment box thanks for your support and uh next month I am going to take another session which is because today I am free for that reason I have taken this class actually I will not take okay all the best guys see you in the next session bye