Forum Discussion

luckycarman's avatar
luckycarman
Copper Contributor
Dec 09, 2020
Solved

Seeking help for setting hyperlink as a batch

I've googled so hard and can't find an answer..... I got Column A (name of the link) and Column B (the URL). I need to create a hyperlink cell which i can simply click and jump to the website (see pi...
excel
Formulas and Functions
Macros and VBA
tauqeeracma's avatar
tauqeeracma
Iron Contributor
Dec 09, 2020

luckycarman Hi

 

You can achieve your requirements using =CONCATENATE() or Concat() function in given way:

 

 

I have also attached a sample file, you just need to apply given formulas from this file to your original file then copy and paste column G as 'values' and finally remove spaces from column G (use find & replace option). After this you can easily delete your original columns.

 

Hope this will help.

 

Please try on test file first.

 

Thanks

Tauqeer

 

luckycarman's avatar
luckycarman
Copper Contributor
Dec 09, 2020
Thank you so much! Can i ask one more question: if there is one more space in column A (e.g. the name is "Microsoft Office"), using find and replace will delete the 2nd space as well, making the name as MicrosoftOffice. Are there quick way to remove the the first space in column G only?
  • tauqeeracma's avatar
    tauqeeracma
    Iron Contributor
    Dec 09, 2020

    luckycarman 

    I have modified the file and used '|' instead of space now you need to replace it.

    Please refer the attached revised file in case you opt for non-VBA solution.

     

    Thanks

    Tauqeer

     

Resources