Forum Discussion
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...
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
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?
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