Mid:
Extracting
Names
Have
you
ever
found
yourself
needing
to
extract
names
from
a
list
of
data?
This
can
be
a
time-consuming
task,
especially
if
the
list
is
lengthy.
Fortunately,
there
is
a
simple
function
in
Excel
that
can
help
you
with
this
task:
‘MID’. ‘MID’
stands
for
‘middle’,
and
as
the
name
suggests,
it
is
used
to
extract
specific
characters
from
the
middle
of
a
text
string.
In
the
case
of
extracting
names,
the
function
can
be
used
to
pick
out
the
first
or
last
name
from
a
list
that
contains
the
full
name
of
each
individual. To
use
the
‘MID’
function
to
extract
the
first
name
from
a
list,
simply
follow
these
steps: 1.
Click
on
the
cell
where
you
want
to
output
the
extracted
name 2.
Type
‘=MID(‘
before
clicking
on
the
cell
that
contains
the
full
name 3.
After
clicking
on
the
cell,
type
「了解更多 姻缘配对知识请关注 :生肖配对网,WWw.shENGXIaopEIDui.cC〗‘,1,FIND(“
“,’
and
then
click
on
the
cell
that
contains
the
full
name
again 4.
Enter
‘)-1)’
followed
by
hitting
Enter This
will
create
a
formula
that
extracts
the
first
name
from
the
full
name.
To
extract
the
last
name,
follow
the
same
steps
but
replace
‘FIND(“
“,’
with
‘FIND(“
“,cell
containing
name)+1,’.
This
will
make
sure
the
last
name
is
extracted
instead
of
the
first
name. Using
the
‘MID’
function
can
save
you
a
lot
of
time
and
effort
when
it
comes
to
extracting
names
from
lists.
It
is
a
simple
yet
powerful
tool
that
can
be
adapted
for
a
wide
range
of
text
extraction
tasks. In
conclusion,
if
you
find
yourself
with
a
long
list
of
names
to
extract,
consider
using
the
‘MID’
function
in
Excel.
It
can
help
you
to
quickly
and
accurately
extract
the
information
you
need,
giving
you
more
time
to
focus
on
other
tasks.