please help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello, I have a spreadsheet with several entries like I have below. Is there an easy way to filter through and just get the names and email addresses? If someone could help me with this, I would really appreciate it. Thanks, Mindy

Aledo High School 1000 Bailey Ranch Roa
Betty Scott
Aledo, TX 76008 12601 High Sta
(e-mail address removed)12.tx.us
Alief Elsik High School 8150 Howell-Sugarlan
Deborah Clemons
Houston, TX 7707
(e-mail address removed)
 
Hi mindy
is your data per name in one cell or do you have always 4 cells for
each entry?
 
Pleas be more specific, how would you like the result laid out? e.g. Name
and email in one cell; name in one cell, email in cell to the right; name in
one cell, email underneath?

Mindy said:
Hello, I have a spreadsheet with several entries like I have below. Is
Click to expand...
there an easy way to filter through and just get the names and email
addresses? If someone could help me with this, I would really appreciate
it. Thanks, Mindy
 
Here it is for Name then email underneath. If your data begins in A1... use
this formula in B1 to get only the name, in B2 to get only the email. Copy
it down as far as need be.

=INDIRECT("A"&ROW()+ROW())


Mindy said:
Hello, I have a spreadsheet with several entries like I have below. Is
Click to expand...
there an easy way to filter through and just get the names and email
addresses? If someone could help me with this, I would really appreciate
it. Thanks, Mindy
 
=INDIRECT("A"&2*ROW())

does the same.

Dave R. said:
Here it is for Name then email underneath. If your data begins in A1... use
this formula in B1 to get only the name, in B2 to get only the email. Copy
it down as far as need be.

=INDIRECT("A"&ROW()+ROW())



there an easy way to filter through and just get the names and email
addresses? If someone could help me with this, I would really appreciate
it. Thanks, Mindy
Click to expand...
 
Back
Top