00:00So what you can also do is utilize ChatGPT in order to generate Excel
00:10formulas as you like. So over here you can see that I got an Excel sheet with a
00:16collection of first name and last names and I want to divide them but I don't
00:20know the formula to do so. In that case I can go around and ask ChatGPT right
00:25here. So I'm going to go around and say in cell A1 I got first name and
00:33last name. Write an Excel formula to divide the first name and last
00:44name right here just like this. So just go around and tell what you want to
00:49do in plain English and it gives you the formula right here for the first name
00:54and the last name as you can see right here. So I'm going to go around and copy
00:58up the code right here and paste this out around over here on cell 1 just
01:02like this and then I'm going to go around over here copy up the code and
01:06paste this out around over here on the last name section as well and this is
01:11what you have as you can see. So apart from this you can go around and select
01:14both of them and click and drag it out right here just like this and then you
01:19can see that the first name and last name now has been divided and that is
01:23how you can go ahead and generate Excel formulas as you like inside of ChatGPT.
01:29So hope you found this video useful. So be sure to comment on what you think
01:33about it. Be sure to hit the like button and don't forget to share this out with
01:37your friends and family and for more contents like these do follow simple
01:42tutorials.
Comments