• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Converting Email Ids entered in Columns in Excel to rows in MS word with Commas

reachkiran03

New Member
Sir I Kiran here I have entered all my clients email ids in excel sheet one by one, now i would like to send a bulk email to all of them very often from my gmail about the series of schemes for which i will be promoting,


My query is how to convert the emtered data to word with commas after each email id
 
Good day reachkiran03


For mailing via Word, in Excel go to save as, in the save as box at the bottom click on the downward pointing arrow and choose CSV(comma delimited)(*.csv)and give it a name, and then open word and open the csv file.
 
1) I st Query - Sir I Kiran here I have entered all my clients email ids in excel sheet one by one, now i would like to send a bulk email to all of them very often from my gmail about the series of schemes for which i will be promoting,


My query is how to convert the entered data to word with commas after each email id .


2nd Query - I have entered two to three pages of email id's continuously like reachkiran03@gmail.com;reachkiran07@gmail.com; etc now i would like to convert them into excelsheet one by one. How can i do it rather than doing it manually.
 
I Kiran


You may want to have a look at Chandoo's Concat example here: http://chandoo.org/wp/2008/05/28/how-to-add-a-range-of-cells-in-excel-concat/


Please note that the comments have a number of extensions to Chandoo's basic UDF which add a lot of extra functionaility
 
Micro loop hair extension is the newest innovation in hair extension technology. These extension strands are attached to the natural hair via micro loop hair extension that secure each strand. Micro hair extension strands are attached at about a distance of 0.4 inches from the scalp.


With micro loop extensions, there is no need for glue or any adhesives to secure the strands which prevents scalp irritation. Also, since no adhesives are used there is no need to iron the extensions thus maintaining the integrity of the natural hair is preserved.


Most of the time, attaching micro loop hair extensions are left to the stylists. Others though prefer to do it themselves but doing so may result in uneven or crooked rows of hair extensions.


Stylist ensure that extension strands are attached via straight sections. Section by section stylists attach the hair using straight rows achieved micro ring loop hair extensions from careful combing. As the stylist takes a small section of the natural hair, twists it, and places the section through the white plastic loop of the loop strand of the micro hair extension. The stylist then pulls the plastic loop tab until the natural hair is threaded and free from the micro bead. Afterwards, the extension hair strands are pulled towards the scalp while clamping down the beads with a pair of pliers. The stylist then moves to another remy loop hair extensions section and carefully attaches each row making sure everything is aligned and even.


Micro loop extension hair requires the same care as that of natural hair. They should be shampooed and conditioned adequately. Most hair extensions come from natural human hair and if not conditioned properly, have the tendency to become dry and matted. Just like normal hair, they must be combed, cleaned regularly and moisturized. Usually stylists require micro ring hair extensions for sale hair to be at least 3 to 4 inches before micro loop extensions can be attached.
 
wigs could be classified into short, half wig cheap hair extensions extension and long. From the style the wigs might be classified into Straight,Curly and Wavy. From the material the wigs might be classified into human hair wigs,Synthetic wigs, European wigs and African American wigs.

Lace wigs are specially created for all those with moderate to serious hair loss, but may be worn by any individual who desires the good quality lace affords. This lace produces the illusion that the hair really grows from the scalp. It truly is made of a fine poly-silk mesh base in which fibers are hand tied to this thin breathable fabric. clip in hair extensions It truly is placed at either the hairline or from the front towards the crown, which can be parted in any direction for maximum styling versatility. They may be light-weight and softer to the touch than regular wigs.

The cheap ray bans sunglasses for every occasion.cheap ray bans If you are a professional and pondering upon upgrading your personalitys eloquence in your office or if you are the regular party animal Ray bans huge collection is the only destination you should be heading for.ray ban sunglasses uk Ray Bans collection also boasts of a wide variety of sunglasses each for men, women and kids.

Nike brand name is one of the most well-known footwear in the globe. clip in human hair extensions new nike air max uk Sneakers are properly known for their longevity, comfort and ease and vast array of choices. Nike shoes are well-known for their quality and delivering greatest functionality.For occasion, which is substantially beautiful, enchanting and interesting footwear for all the entire world wide sportsmen.cheap nike air max 2012 They not only give you a sheer piece of control in your life but human hair extensions also give you a huge mental relaxation. The footwear are utilized for informal wear and sportswear.
 
1) I st Query - Sir I Kiran here I have entered all my clients email ids in excel sheet one by one in a column, now i would like to send a bulk email to all of them very often from my gmail about the series of schemes for which i will be promoting,To do so I should enter in word file as reachkiran03@gmail.com;reachkiran07@gmail.com; one by one, doing the same is a time consuming process. Can you sugggest me some solution.


My query is how to convert the entered data to word with commas after each email id .


2nd Query - I have entered two to three pages of email id's continuously like reachkiran03@gmail.com;reachkiran07@gmail.com; etc in a word file, now i would like to convert them into excelsheet one by one. How can i do it rather than doing it manually.
 
Reachkiran03


1. If you Concatenate all the Emails together using one of the solutions at

http://chandoo.org/wp/2008/05/28/how-to-add-a-range-of-cells-in-excel-concat/

You will have a string of emails with separators as you require


2. If you have a list of email ID's in Word

Copy/paste into Excel

Reformat as appropriate

Depending on how they were setup you may need to use Text to Columns
 
Back
Top