+ Reply to Thread
Results 1 to 6 of 6

how to change a load of cell names to have a http in front of them

  1. 10-04-2023, 06:05 AM #1
    kimblonde
    kimblonde is offline
    Registered User
    Join Date
    08-06-2023
    Location
    leic
    MS-Off Ver
    2007
    Posts
    12

    how to change a load of cell names to have a http in front of them

    Hi
    I have a csv file with three colums

    web page....... email......... password

    freds.com........email .......freds234


    What I want is to change the webpage name to have a full webpage address and not just the name
    I hope you under stand as it will not let me put in the web page address

    If I had just a few I could do it by hand BUT GOT OVER 200 to do

    Hoping someone can help me

    thank you

    Kim
    Attached Files Attached Files
    Last edited by kimblonde; 10-04-2023 at 06:31 AM. Reason: attchmet
    Reply With QuoteRegister To Reply
  2. 10-04-2023, 06:19 AM #2
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,447

    Re: how to change a load of cell names to have a http in front of them

    Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  3. 10-04-2023, 06:31 AM #3
    kimblonde
    kimblonde is offline
    Registered User
    Join Date
    08-06-2023
    Location
    leic
    MS-Off Ver
    2007
    Posts
    12

    Re: how to change a load of cell names to have a http in front of them

    Quote Originally Posted by TMS View Post
    Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.
    hope okay for you
    Reply With QuoteRegister To Reply
  4. 10-04-2023, 06:43 AM #4
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,447

    Re: how to change a load of cell names to have a http in front of them

    The easiest way would be to put this in a helper column:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    and copy it down.

    Then copy the output from the helper column and Paste Special | Values over the original data. Then you can delete the helper column.
    Reply With QuoteRegister To Reply
  5. 10-04-2023, 11:57 AM #5
    kimblonde
    kimblonde is offline
    Registered User
    Join Date
    08-06-2023
    Location
    leic
    MS-Off Ver
    2007
    Posts
    12

    Re: how to change a load of cell names to have a http in front of them

    Quote Originally Posted by TMS View Post
    The easiest way would be to put this in a helper column:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    and copy it down.

    Then copy the output from the helper column and Paste Special | Values over the original data. Then you can delete the helper column.
    Great help that was so quick and did the job just has I wanted it . just made one mistake I did not notice that i had some www in the cells and of cause it put in th www twice BUT no problem I just went and change them and took out the www bit and all worked fine.

    MANY MANY THANKS

    KIM
    Reply With QuoteRegister To Reply
  6. 10-04-2023, 12:02 PM #6
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,447

    Re: how to change a load of cell names to have a http in front of them

    You're welcome. Thanks for the rep.



    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Retrieving file names from an http server in VBA - Dir won't work
    By blackworx in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-05-2020, 02:40 AM
  2. change listbox load value based on cell value
    By kmakjop in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-18-2014, 11:10 AM
  3. How do I add http://www. to the beginning of 500 domain names all at once
    By Domaineroo in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-12-2012, 04:40 AM
  4. [SOLVED] Adding "http://" to the front of a column of web URLs that start with www
    By scottlin in forum Excel General
    Replies: 6
    Last Post: 08-16-2012, 11:53 AM
  5. Excel 2007 : automatically load chart title in front of list
    By ncaucino in forum Excel General
    Replies: 8
    Last Post: 04-28-2011, 10:57 AM
  6. Change CSV-load cell format from GENERAL to TEXT for numbers?
    By Morena Chris Matthews in forum Excel General
    Replies: 1
    Last Post: 10-14-2005, 01:05 PM
  7. Microsoft Excel tries to load front page on opening
    By Excel and Front Page in forum Excel General
    Replies: 1
    Last Post: 03-21-2005, 05:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1