Merging columns...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mike - 14 Jul 2006 18:41 GMT

I am trying to create a text file of email addresses.
I have exported my addressbook from Outlook & deleted all the info I don't
want & am left with 3 columns, First name, Last name & Email address.
I would like for them to wind up in a text file following the format
"FirstName LastName" <name@domain.com>
Complete with the quotation marks & greater than, less than symbols.
Any advice appreciated...

Reply to this Message

Dave Peterson - 14 Jul 2006 19:00 GMT

=char(34) & a1 & " " & b1 & char(34) & " <" & c1 & ">"

char(34) is the double quote character.

> I am trying to create a text file of email addresses.
> I have exported my addressbook from Outlook & deleted all the info I don't
[quoted text clipped - 3 lines]
> Complete with the quotation marks & greater than, less than symbols.
> Any advice appreciated...

Signature

Dave Peterson

Reply to this Message

Mike - 14 Jul 2006 19:08 GMT

I forgot to add that I'm an excel dummy.
What do I do with this?

> =char(34) & a1 & " " & b1 & char(34) & " <" & c1 & ">"
>
[quoted text clipped - 8 lines]
>> Complete with the quotation marks & greater than, less than symbols.
>> Any advice appreciated...

Reply to this Message

Dave Peterson - 14 Jul 2006 20:38 GMT

Put your data in columns A to C.

Firstname in column A
lastname in column B
email address in column C

Then put this formula in D1
and drag down the rows that you need

Debra Dalgleish shows how to fill those rows:
http://contextures.com/xlDataEntry01.html

> I forgot to add that I'm an excel dummy.
> What do I do with this?
[quoted text clipped - 15 lines]
> >
> > Dave Peterson

Signature

Dave Peterson

Reply to this Message

Mike - 15 Jul 2006 05:16 GMT

It works in the 1st row, but that's it.
What do you mean by "drag down the rows that you need"?
I did mention that I was excel-illiterate, didn't I?
Thanks for your patience...

> Put your data in columns A to C.
>
[quoted text clipped - 27 lines]
>> >
>> > Dave Peterson

Reply to this Message

Dave Peterson - 15 Jul 2006 12:20 GMT

Take a look at Debra's site.

She has pictures to show how to drag the formula down the column to fill the
cells under the original cell.

> Debra Dalgleish shows how to fill those rows:
> http://contextures.com/xlDataEntry01.html

> It works in the 1st row, but that's it.
> What do you mean by "drag down the rows that you need"?
[quoted text clipped - 36 lines]
> >
> > Dave Peterson

Signature

Dave Peterson

Reply to this Message

Mike - 15 Jul 2006 14:20 GMT

Thank you!

> Take a look at Debra's site.
>
[quoted text clipped - 49 lines]
>> >
>> > Dave Peterson

Reply to this Message