5 {{ upvoteCount | shortNum }}
5 {{ upvoteCount | shortNum }}

Any excel masters in here?

by evanlambda
4 replies
I use excel a lot, usually in a way it was probably not intended but oh well. I use it to keep track of a lot of URLs, for example.

Lets say I have a bunch of URLs: some with http://, some with www., some with both or neither. How do I change all URLs in a column so that only the part after the http:// or the www. will be displayed?

I can copy it and write a script to do it, but Im trying to figure out how to do this in excel only.

Any advice is appreciated.
#excel #masters
  • Profile picture of the author neodarth
    Replace (ctrl l) the http:// with "", do the same with the www.
    Signature
    ==> Negocios Estables en la Web Internet marketing en español.

    ==> Internet Marketing Newbie Created for IM virgins
    {{ DiscussionBoard.errors[2683340].message }}
  • Profile picture of the author Dennis Wagoner
    If you want to remove those extra parts do a Search and Replace.

    Search for the http://www. and replace with blank.

    Same for the www.

    If you are trying to do something else, please clarify.
    Signature

    {{ DiscussionBoard.errors[2683360].message }}
  • Profile picture of the author WarForNom
    Originally Posted by evanlambda View Post

    I use excel a lot, usually in a way it was probably not intended but oh well. I use it to keep track of a lot of URLs, for example.

    Lets say I have a bunch of URLs: some with http://, some with www., some with both or neither. How do I change all URLs in a column so that only the part after the http:// or the www. will be displayed?

    I can copy it and write a script to do it, but Im trying to figure out how to do this in excel only.

    Any advice is appreciated.
    Doubtless all the information you will need is here:

    Microsoft Excel Tips - Excel.Tips.Net

    Sort of an Excel Warrior Forum.
    {{ DiscussionBoard.errors[2683520].message }}
  • Profile picture of the author Amy Carczak
    Use "Text to Columns" and it will work
    perfectly ...
    {{ DiscussionBoard.errors[2683580].message }}

Trending Topics