extracting substring with 2010

Key Takeaways

hi friends this is Excel Guru rajinikant and this query asked by uh in a group actually this query already I posted in groups but one of one of the group members soled this with another very big formula so I like to show you the simple way very very very very simple way right so here is the solution for that so first of all what you'll do you'll take a mid function very simple formula very very very simple formula mid of this comma starting from here and take the number of characters will be length Okay this one all right it's very simple just observe guys what I'm doing here first of all I'm taking the text lat starting number from five and I need from five I need each and every character from five from five I need each and every character right so here I press enter so from five it will pick up all the characters from five okay now here is the logic you have to follow it's very simple easy right so what I'll do here I will find the space F2 I'll find the space here the the position then where the space is there okay space in this text in this text I'm finding the space okay so it will show you the sixth okay control Z and come back to Here Close enter Right double click again double cck okay now here done now what I do again I use the same formula which I have done that is mid of mid of this comma starting number this comma and the solution is done and the solution is done see let me check is there any Extra Spaces are there we have to check it if it is Extra Spaces you can use a trim function so let's check it out okay length of length of this the desired output comma the length of formula just now we did okay sorry the L this first you will take that one and again I'll pick up the that one length of this the formula which we because it may be have some extra spaces C6 right understood so it has given six okay see so simply use a trim function over here after not here the formula which we have done here after trim off trim off whole thing ENT because extra space has been taken now see now observe here then it's very easy guys if you have any doubt you can ask me in the comment box and please like share and subscribe and this is the very very important question which I which I have asked earlier in some group right thank you guys thanks for your support please please please share and subscribe for this video I'm expecting minimum 100 views with 50% of Lights