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? I would like the name in one cell and the email address in the adjacent cell (i.e A1 B1) If someone could help me with this, I would really appreciat
it. Thanks, Mind
Aledo High School 1000 Bailey Ranch Roa
Betty Scot
Aledo, TX 76008 12601 High Sta
(e-mail address removed)12.tx.u
Alief Elsik High School 8150 Howell-Sugarlan
Deborah Clemon
Houston, TX 7707
(e-mail address removed)
 
?

Did my solution not work?


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? I would like the name in one cell and the email address in the
adjacent cell (i.e A1 B1) If someone could help me with this, I would really
appreciate
 
The first solution extracted them into seperate rows same column. I got an
email yesterday though, from her, about how to get it in A1 and B1 instead
of A1 and A2.

I sent her

=INDIRECT("A"&2*ROW())
for first row name column

=INDIRECT("A"&ROW()*3+ABS(ROW()-2))
for the rest of the rows in name column

and

=INDIRECT("A"&4*ROW())
for all rows in email column.

They worked for me.
 
Hi Dave,
Your suggestion worked, thanks so much and I apologize for last night. One more question, how can I copy the names and email addresses to another worksheet and display the information and not the formulas?

----- Dave R. wrote: ----

The first solution extracted them into seperate rows same column. I got a
email yesterday though, from her, about how to get it in A1 and B1 instea
of A1 and A2

I sent he

=INDIRECT("A"&2*ROW()
for first row name colum

=INDIRECT("A"&ROW()*3+ABS(ROW()-2)
for the rest of the rows in name colum

an

=INDIRECT("A"&4*ROW()
for all rows in email column

They worked for me
 
Glad it worked.
You select that range, copy it, go to the other worksheet. Go to Edit>paste
special> and click "values" then OK, and you'll have only the text, not the
formulas.



Mindy said:
Hi Dave,
Your suggestion worked, thanks so much and I apologize for last night.
Click to expand...
One more question, how can I copy the names and email addresses to another
worksheet and display the information and not the formulas?
 
Hahah Peo.

Thankfully I have no experience with apologizing to women for last night!!

I'm sure any other red blooded man who posts here would attest to the same
:)
 
Prefer not to open a worksheet, especially here at work.

How has it "stopped working" and you are of course making sure the data is
in the same pattern?

One thing to try, is to copy/paste special/values what HAS worked, then
delete the section of the source data (with the delete key, not by deleting
the cell entirely) that has already been gone-through, and copy into its
place the rest of the addres/name/school/email info.

You understand what I mean? Extract what you can, then copy the extracted
data elsehwere, then copy a new bunch of source data in to have the
name/email extracted, copy that elsewhere, etc.

That is a brute force approach but those usually work.



Mindy said:
I think I spoke too soon, the name/email formula worked for half of
Click to expand...
the spreadsheet but it stopped working, would it be okay if I sent the
spreadsheet to you and maybe between the two of us we can figure it out?
 
Probably not. Hopefully it can be solved with the suggestions already given.


Mindy said:
You know, I have a comment I could make but since I don't know you I will
Click to expand...
keep my mouth shut! :) Anyway, I'm going to be away from the computer for
awhile but will you be around later to solve this problem?
 
Back
Top