Hi, I have a list of domain name, I want to seperate words in those domain names, I tried using MS Word, but I don't know how to do it, if there is any tool for separating words, please let me know. For example, I have a list of domain names: yalcinyapibandirma.com yalegps.com yalvacsuculludergisi.com yalvactv.com yamabico.com yamaha200x.com yamahadiagnostic.com yamashiroen.com yamato-leather.com yambasu.org yampavalleyfh.com yandttransmissions.com yanf123.com yang-banger.biz yangindolabiimalati.com yangshiji.com yanhuifuwu.com yani888.com yanidaframe.com yanidimoff.com yanjieqw66.com yankeeschoke.net Removing, .com/.net is easy.. but I want to separate each word so that I can put it in Adwords keyword tool to find how many searches are for one keyword. Let me know.
Select the topmost cell in the column, e.g. A1 Hold CTRL+SHIFT and then press the down arrow. OK, once we've done that, go to "Data" menu and select "Text To Columns". On the Text To Columns window, select "Fixed Width" and then hit "Next". Create the line break then just click on Finish. Done.