Merging columns...

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...

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

char(34) is the double quote character.

Mike wrote:
>
> 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...

--

Dave Peterson

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

"Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
news:44B7DBCA.2F8249AA@verizonXSPAM.net...
> =char(34) & a1 & " " & b1 & char(34) & " <" & c1 & ">"
>
> char(34) is the double quote character.
>
> Mike wrote:
>>
>> 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...
>
> --
>
> Dave Peterson

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

Mike wrote:
>
> I forgot to add that I'm an excel dummy.
> What do I do with this?
>
> "Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
> news:44B7DBCA.2F8249AA@verizonXSPAM.net...
> > =char(34) & a1 & " " & b1 & char(34) & " <" & c1 & ">"
> >
> > char(34) is the double quote character.
> >
> > Mike wrote:
> >>
> >> 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...
> >
> > --
> >
> > Dave Peterson

--

Dave Peterson

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...

"Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
news:44B7F2C2.9198022D@verizonXSPAM.net...
> 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
>
> Mike wrote:
>>
>> I forgot to add that I'm an excel dummy.
>> What do I do with this?
>>
>> "Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
>> news:44B7DBCA.2F8249AA@verizonXSPAM.net...
>> > =char(34) & a1 & " " & b1 & char(34) & " <" & c1 & ">"
>> >
>> > char(34) is the double quote character.
>> >
>> > Mike wrote:
>> >>
>> >> 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...
>> >
>> > --
>> >
>> > Dave Peterson
>
> --
>
> Dave Peterson

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

Mike wrote:
>
> 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...
>
> "Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
> news:44B7F2C2.9198022D@verizonXSPAM.net...
> > 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
> >
> > Mike wrote:
> >>
> >> I forgot to add that I'm an excel dummy.
> >> What do I do with this?
> >>
> >> "Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
> >> news:44B7DBCA.2F8249AA@verizonXSPAM.net...
> >> > =char(34) & a1 & " " & b1 & char(34) & " <" & c1 & ">"
> >> >
> >> > char(34) is the double quote character.
> >> >
> >> > Mike wrote:
> >> >>
> >> >> 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...
> >> >
> >> > --
> >> >
> >> > Dave Peterson
> >
> > --
> >
> > Dave Peterson

--

Dave Peterson

Thank you!

"Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
news:44B8CF77.6FEF27A1@verizonXSPAM.net...
> 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
>
> Mike wrote:
>>
>> 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...
>>
>> "Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
>> news:44B7F2C2.9198022D@verizonXSPAM.net...
>> > 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
>> >
>> > Mike wrote:
>> >>
>> >> I forgot to add that I'm an excel dummy.
>> >> What do I do with this?
>> >>
>> >> "Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
>> >> news:44B7DBCA.2F8249AA@verizonXSPAM.net...
>> >> > =char(34) & a1 & " " & b1 & char(34) & " <" & c1 & ">"
>> >> >
>> >> > char(34) is the double quote character.
>> >> >
>> >> > Mike wrote:
>> >> >>
>> >> >> 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...
>> >> >
>> >> > --
>> >> >
>> >> > Dave Peterson
>> >
>> > --
>> >
>> > Dave Peterson
>
> --
>
> Dave Peterson