Can you please help me out on the following scenario which I face quite often.
1. www.facebook.com
2. www.twitter.com
3. www.gr8.com
.
.
.
.
.
123. www.shop.com
.
.
.
.
1899. www.buy.com
.
.
.
Now, The scenario - When I have information copied to an excel sheet from online, the cell also captures the numbering as on site (as mentioned above). I do not need this numbering, but just the site name. The concern is, the site name may be only alphabetical, or alpha-numeric also. I cannot afford to spend time changing every cell without the numbering.
Is there a quick fix solution when faced with this scenario? I'm not an expert with excel, so a simple solution will be appreciated.
Bookmarks