how to find max length word from text string

Key Takeaways

okay from starting i'd explain you once again guys due to some uh problem i'm unable to do that well i'll explain you once again just i'll press something something wait a minute guys wait a minute [Music] match type comma zero a minute just simply i did this one not the correct accurate one so i'll do a little okay i'll do here okay now see here well let's lock it first of all you have to accept each and every word before it was a mute for that reason i rescheduled the video chat again sorry for that and now see what i'll do step by step i'll show you first of all what you'll do made of made of substitute of i'm adding space to the that value ampersand this one and old text will be space and the new text i'm adding or i am replacing or i'm substituting substituting a new value a new character that is space how many times 255 times okay and starting number what i'll use 1 into 255 comma 255 so it will give you the first word from the text string if i highlight f9c my but before that i'll use a trim function over here trim f9 see the first word from the text string instead of one if i use two it will show you the second word birthday if i use three over here it will extract third word that is ease so i want to find the length of the maximum character word that is birthday so you have to extract birthday over here right so what i'll use first of all i want to use this formula again and again so i'm copying this formula and i'm using what am using here that is okay okay index of this whole thing array this is an array index of the whole thing right okay we're not here i'll show it simply i'll what i'll do before that wait a minute before that what i'll do i'll show you one trick that is you want to extract each and every word from the texting by using row and indirect function that is this one so it will extract each and every word right one two how many words are there totally 26 words are there including a space see if i press enter now i'll show you is equal to length of this see that that is the thing i did here totally 26 update f9 see including space so ctrl z control c so i use this formula over here that is in display control v now see what will happen it will extract each and every word each and every word differently including the space see my birthday is on differently and if you have any doubt ask me in the group or in the comment box now what i'll do i need this formula i'll copy this formula and what i'll use here the simple logic what i'll use index index of this whole thing the array part that is f9 this part this will i'm converting this into an array by using index function comma and we need the row so what i'll use match of max of length this whole text now i'll show you what will happen lookup value will become f9 see here i will show you so that you can able to understand f9 c2 8 word is two letters second word is eight letters third word is two letters again fourth word is on letters all two words and june is fourth letters word length of the word is four letters right so what will