00:09so over here you can see that I have an Excel seat and I got these names right here and
00:14the
00:14number but let's say what I want is I want to remove the numbers before the name so but I
00:21don't
00:22know how to write a formula for it that is where Kimmy actually can help so I'm just going to
00:28go
00:28around and say in Excel I got a cell with one dot two dot three dot in the beginning of
00:38text I want
00:40to remove them write a formula for it the source text is in A1 right here so I'm just going
00:56to go
00:56around over here and type that in so I'm saying source text as A1 right here and it says substitute
01:02the function so you can see that it says one two three only right here so I'm just going to
01:07go
01:07around and say I'm going to add in from remove all numbers from one to ten right here just like
01:17this
01:18so I can simply go ahead right here and then what happens is that it'll go ahead and give me
01:23the
01:23updated formula right here just like this you can see that it removed from one to ten so let me
01:30just
01:30go ahead and copy this out right here it's using the trim fold formula so let's just go ahead and
01:35paste this and then you can see that the number is removed simply click and drag it and everything
01:41will be removed so you can see that I got first name and last name right here and let's say
01:46I want
01:47another formula to remove first name and last name so I'm going to say in B1 I got I got
01:55first name and
01:57last name write a formula to divide them into first name in one cell and last name in another cell
02:10so
02:11just like this I'm simply going to write everything in plain English and it'll go ahead and give me a
02:17formula for it so it says to split the first name and last name from single B1 to two separate
02:22cells
02:23this is what you have right here so it give me two formulas so let's just go ahead and copy
02:28this first
02:28formula out right here and then I'm going to go ahead and paste this and you can see that you
02:33got the
02:34first name and then I'm going to go ahead and copy out the last name right here just like this
02:39and paste this
02:40out and you got the last name right here so let's just go ahead and then paste this out so
02:46there is
02:47an error right here that's going on so let's just go ahead on to write copy this out right here
02:53and then
02:54I'm simply going to go ahead and paste this out right here so it says there is a problem because
03:00it's
03:00not working so I can simply go ahead and see like let's say for example this um formula isn't working
03:10right here just like this so let's just go ahead and then say that and then it'll give me a
03:16correct
03:17uh code so sometimes it does actually go ahead and then um uh fine um do do an error so
03:25I'm just
03:26going to go ahead and copy this out it gave a corrected code as you can see let's just go
03:30ahead
03:30and there you go so now you can pull this out and then you got the first name and last
03:35name divided
03:36and this is how you can actually go ahead and then uh generate out uh excel seed formulas um inside
03:45of
03:45kimi so hope you guys learned something as always and as always please like comment share and subscribe
04:00you