IDN Forums - Internationalized Domain Names  
Home | Advertise on idnforums | Premium Membership

Go Back   IDN Forums - Internationalized Domain Names > IDN Discussions > General Discussion

General Discussion Feel free to talk about anything and everything in this board.

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 22nd May 2010, 05:16 PM
Moderator
 
Join Date: Dec 2005
Posts: 7,864
iTrader: (60)
Rep Power: 2200
bwhhisc will become famous soon enoughbwhhisc will become famous soon enoughbwhhisc will become famous soon enoughbwhhisc will become famous soon enoughbwhhisc will become famous soon enoughbwhhisc will become famous soon enoughbwhhisc will become famous soon enoughbwhhisc will become famous soon enough
Excel help

I have a list of terms I want to add .com to the entire list.

They are all unique words, so no opportunity to use the "find and replace" tool.

Any quick tricks to do this automatically with excel? Thanks.
Reply With Quote
  #2 (permalink)  
Old 22nd May 2010, 05:29 PM
bramiozo's Avatar
Administrator
 
Join Date: Sep 2005
Location: Haarlem
Posts: 2,251
iTrader: (30)
Rep Power: 929
bramiozo is on a distinguished roadbramiozo is on a distinguished roadbramiozo is on a distinguished roadbramiozo is on a distinguished roadbramiozo is on a distinguished roadbramiozo is on a distinguished road
Send a message via MSN to bramiozo Send a message via Skype™ to bramiozo
Re: Excel help

download notepad++,
copy column of names to notepad++, then do :
ctrl+h, activate regular expression under search mode.
find : ([^\s]+)\s*$
replace : \1.com
Reply With Quote
  #3 (permalink)  
Old 22nd May 2010, 05:36 PM
Veteran
 
Join Date: Sep 2005
Posts: 2,699
iTrader: (50)
Rep Power: 1246
gammascalper is on a distinguished roadgammascalper is on a distinguished roadgammascalper is on a distinguished roadgammascalper is on a distinguished roadgammascalper is on a distinguished roadgammascalper is on a distinguished road
Re: Excel help

If the names are in column A, then in Column B type in =A1&".com"

Then copy and paste that all the way down.
__________________
-----
Offers by e-mail, PM or forum post valid for 5 days
Reply With Quote
  #4 (permalink)  
Old 22nd May 2010, 06:11 PM
Moderator
 
Join Date: Dec 2005
Posts: 7,864
iTrader: (60)
Rep Power: 2200
bwhhisc will become famous soon enoughbwhhisc will become famous soon enoughbwhhisc will become famous soon enoughbwhhisc will become famous soon enoughbwhhisc will become famous soon enoughbwhhisc will become famous soon enoughbwhhisc will become famous soon enoughbwhhisc will become famous soon enough
Re: Excel help

Quote:
Originally Posted by gammascalper View Post
If the names are in column A, then in Column B type in =A1&".com"

Then copy and paste that all the way down.
Thanks, that works

And figured out how to "drag" the right bottom corner of the first cell all the way to bottom to add ".com" to the whole list.
Very nice trick, thanks!

Last edited by bwhhisc; 22nd May 2010 at 06:17 PM..
Reply With Quote
  #5 (permalink)  
Old 22nd May 2010, 10:02 PM
bramiozo's Avatar
Administrator
 
Join Date: Sep 2005
Location: Haarlem
Posts: 2,251
iTrader: (30)
Rep Power: 929
bramiozo is on a distinguished roadbramiozo is on a distinguished roadbramiozo is on a distinguished roadbramiozo is on a distinguished roadbramiozo is on a distinguished roadbramiozo is on a distinguished road
Send a message via MSN to bramiozo Send a message via Skype™ to bramiozo
Re: Excel help

...or you can do that .
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT. The time now is 03:27 AM.

Site Sponsors
Your ad here
buy t-shirt
מחיר הזהב

Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.3.0
Copyright idnforums.com 2005

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54