Merging columns...

[Mike]

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" <[email protected]>
Complete with the quotation marks & greater than, less than symbols.
Any advice appreciated...

 

[Dave Peterson]

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

char(34) is the double quote character.

 

[Mike]

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

 

[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]

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]

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"?
I did mention that I was excel-illiterate, didn't I?
Thanks for your patience...

 

[Mike]

Thank you!

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.