Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Combining text
I have an electronic newsletter that I send out once/month that I export the
addresses to an Excel worksheet. I need to be able to combine all address (over 300) with a comma between to copy and paste to the newsletter. Help! |
#2
|
|||
|
|||
What format is your data currently in? If, for instance, Name is in
column A, Address in column B, City in col C, and you need to create a single comma delimited entry, you can use =A1&","&B1&","&C1 Does that do what you need? |
#3
|
|||
|
|||
You might want to try saving the file as as CSV (Comma Delimited) file rather
than XLS. Then instead of using Excel to open the CSV file, try using a text editor like Notepad to open it. You'll see your addresses with commas in between. Enjoy! =P Ralph Dy Bautista "God is real...unless declared an integer..." "Ruthe6" wrote: I have an electronic newsletter that I send out once/month that I export the addresses to an Excel worksheet. I need to be able to combine all address (over 300) with a comma between to copy and paste to the newsletter. Help! |
#4
|
|||
|
|||
Hi Ruth,
You may have trouble mailing 300 all at once from most home user ISP accounts. You may also have trouble with one very large concatenation due to limits in Excel. But you can use simply end each name with a comma or semicolon =Trim(a1)&"," and copy down then copy and paste your B column into the To or BCC area. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Ruthe6" wrote in message ... I have an electronic newsletter that I send out once/month that I export the addresses to an Excel worksheet. I need to be able to combine all address (over 300) with a comma between to copy and paste to the newsletter. Help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining text from multiple columns into 1 | Excel Discussion (Misc queries) | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
Combining numerical and drop-down text in a single cell | Excel Discussion (Misc queries) | |||
Combining & formatting cells with text - Excel 2002 | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |