TELEGRAM QUERY BY RISHABH

Key Takeaways

hi friends this is Excel Guru once again with a query by rishab in telegram group so here I'm going to share a solution and I will explain you how to do all those things before going to screen please I request everyone like share and subscribe after subscribe click on Bell icon so that whenever I upload any query any interview questions Excel interview questions then you will get a notification right so I'm expecting nearly 1,000 views plus th000 likes because it's very very important query here is the screen which I'm going to share with you guys see here is the screen so here is that you have to split by rows and columns with a single formula single formula means I going to say that you can use multiple formulas in one sing one cell okay like uh but not in another cell like you can use mid lat you will use left right no no no no not like that you have to use only one formula I mean to say the ne formula but it it should be a one formula right so it has to split like this and like this okay row as rows and columns see how I'll do first of all I'll take a mid of this mid substitute of what is the delimeter over there there is a space double space right so what I'll use space iyon space okay I'm adding a new I'm adding prefix for this value comma what will be the old text as we know that old text is this one space this one and instead of old space What will be the new text you have to add so I'm adding space 255 times why 255 because in one cell it will allow 255 characters for that reason maximum number of you can use 100 also right for that reason I'm using maximum 250 we don't need instance just close it and starting number here from here you will see all the Magics okay start starting number is suppose 1 into 255 comma 255 okay example I'm showing you right I press F9 so it is showing only 92 okay I will use trim function for this trim okay so it will pick a first character exactly but I want to extract as a column and rows with only one formula instead of one what I use F2 what your I have not Lo this one F4 it should not move anywhere and another thing is that only that thing right okay right let's check it out rowwise this one is rowwise okay the first value I mean to say the 92 92 b 29 understood only this value it is taking rowwise okay now this value it should be a column wise like this okay so what I'll do here instead of rows I will take colum dollar B B2 colon b 2 into 255 into 255 right now see okay I loged only this one so I have to remove the this one F4 it should move right now see control R control D go it if you want it's a very very Dynamic way if you want you can go through it and check it see here I'm adding another one okay let's see I'm adding another one like uh some x y z okay here you can see XY Z here again got it this is the dynamic way I will show you the formula here that is Formula text done if you want many more things you can ask me and thank you thank you guys thanks for your support