Up next in 10
Excel AI Extract Function Will Make Your Life 10x Easier!
816 views
Feb 9, 2025
Unlock the power of Excel AI with the Extract function! This game-changing feature automates data extraction, saving you time and effort. Whether you need to pull key details from messy text, clean up large datasets, or streamline your workflow, Excel AI’s Extract function does it all in seconds—no formulas needed! Say goodbye to manual data sorting and hello to smart automation. Powered by advanced AI, this tool works like ChatGPT for Excel, helping you extract structured data effortlessly. Watch the video to see real-world examples and learn how to boost productivity with AI in Excel! #ExcelAI #ExtractFunction #ChatGPTForExcel
View Video Transcript
0:01
hello everyone welcome back to our
0:03
Channel if you're new here uh this is
0:05
Exel whis and today we are diving into
0:07
something super exciting that is using
0:10
the AI extract function in Excel whether
0:13
you're a data analyst or just a student
0:15
or someone who just loves working with
0:18
spreadsheets this powerful AI tool can
0:20
save you a ton of time and effort so in
0:23
the next couple of minutes I'll walk you
0:25
through how to use AI extract function
0:28
step by step showing you a real life
0:30
example and tips along the way so grab
0:33
your Excel files and let's get started
0:38
together a I extract works the same as
0:42
flash F in the normal way that we use
0:45
Exel uh an example is when you let's
0:49
take this example that we have here we
0:51
have our first names our last names and
0:54
a column of combined this is where you
0:56
can just type in Let's uh say using this
1:00
example we can type in
1:03
William Ruto and then just select select
1:08
your cell and then contrl e and you'll
1:12
have then your
1:15
names combined all your names combined
1:18
at the same time so this is how you do
1:22
it normally with Flash Fill but in this
1:24
example we are going to I'll going I'm
1:27
going to show you how to use the AI
1:29
extract to get similar results but this
1:31
one is a bit easier and a bit faster so
1:35
you may opt out to use this so let's get
1:38
started the very first thing that you
1:40
need to do you have to ensure that your
1:43
Exel has chart GPT for Exel I've
1:46
explained this in a different video if
1:48
you don't know how to do that please go
1:51
back and watch one of our videos showing
1:53
this and then come back and continue
1:55
with this video once you've done
1:58
that once you've done that the next
2:01
thing that you'll come and do is for
2:03
this particular example we have our
2:06
names and a couple of sentences here
2:09
that contains different names so we have
2:12
our outputs on the right side and we
2:15
just want to extract the names that is
2:17
William Ruto Joe Biden Kamar Harris and
2:20
the rest we only need to extract the
2:22
names and nothing else so if we were
2:25
using the flash field we'll just come
2:28
here and uh like we did earlier type in
2:31
William
2:32
Bruto and then just uh select the cell
2:36
and control
2:38
e see since we are missing some values
2:41
or just highlight it
2:44
and select it and
2:48
drop contr e once you do contrl e you
2:52
see this time around it's not working as
2:55
it was here because we don't have any
2:57
more data it will just give you the same
2:59
name over and over but this is not what
3:02
we want to
3:07
do so what we need to do is just use the
3:11
AI extract to be able to extract just
3:15
the name so what you need to do just
3:17
type in the AI extract ai. extract
3:20
formula you have it as the third choice
3:24
so click on it and then you have this
3:27
formula AI do extract you have to need
3:30
to have the value that you're extracting
3:33
your information from and the extract is
3:36
the exact thing that you need to extract
3:39
or to put in your sheet so our value in
3:42
this particular case is uh
3:46
this it's this information that you've
3:49
typed in here so you select it uh type
3:52
in comma and then your extract now in
3:55
this particular case is names click on
3:58
names and close your parenthe this is
4:00
and hit enter chpt will do its thing and
4:04
as you can see you have your names
4:06
William rutto Joe Biden Kamara Harris
4:08
Michelle Obama Jan Clinton and Hillary
4:11
white all of them combined just as we
4:14
used the flash fi on the right side here
4:17
so as you can see it's that easy just
4:21
you just need to know the value you just
4:24
need to select the value the range of
4:26
the value where your names or whatever
4:29
thing that that you need to be extracted
4:31
is and just to show you that you can
4:35
actually extract more information we'll
4:38
get we'll move on uh to this other
4:40
example where we have a couple of emails
4:43
here there are different emails so we
4:47
just come here in an empty cell click AI
4:51
the formula ai. extract it's the third
4:54
one just click on it as we said earlier
4:58
you select the range of your values
5:00
where your values are are click comma
5:04
and then select the extract what do you
5:07
need extracted from the range of values
5:10
that you've currently selected at this
5:12
particular point you only need the
5:14
emails so close your parenthesis and hit
5:17
enter and chat TPT will do it
5:20
thing as you can see we have chip has
5:24
extracted all our emails and by this the
5:28
third email Kamara tre.com this is not
5:31
an email this is why chpt has written
5:34
that it's not found so what you can do
5:37
you can just go back to your the range
5:40
of your values and correct that email
5:43
and you'll get the exact values that you
5:46
need so this is what you just need to do
5:49
it's that simple it's just a similar way
5:52
of us rather than using the flash Feld
5:55
you just use ai. extract so if you have
5:59
any question questions feel please feel
6:01
free to ask in the comment section if
6:03
you have similar ways that you'd like us
6:06
or if you'd like um as to do a different
6:09
video concerning anything please feel
6:12
free to type in in the comment section
6:15
as always thank you very much for
6:17
watching and see you again in the next
6:19
video bye