Hi, I'm new here, I'm looking for help please
I have a excel table with Product name in column A and picture links in column B
Each link have its own row example column A there's product row X1 X2 X3 (the same product) because there 3 picture links for the same product and Y1 Y2 Y3 Y4 = 4 links etc
I need to merge the links in one cell for each products
I don't know if that's clear
Thanks in advance
Screenshot 2024-01-23 215209.png
Last edited by 6StringJazzer; 01-23-2024 at 11:40 PM. Reason: better titles please
Welcome to the Forum Simon133!
In Excel you cannot have more than one hyperlink in one cell.
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
ok what about regular text how can i do it ?
yes you can have multiple hyperlink in the same cell if they are separated by this symbol |
is there a visual basic script for something similar to xlookup for this i have over 12,000 links that i need to merge
ByteMarks has the best solution.
You can have the text for multiple URLs in the same cell, but a cell can only have one hyperlink. They are not the same thing.Originally Posted by Simon133
Yes this is what I need, can you help me merge them as text
?
Administrator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #1 requires good titles. I have updated it for you this time because you are a new member. --6StringJazzer
Shall I move this to the Formulas section? It seems to be in the wrong forum section.
There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.
A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
I was thinking you could perhaps create a data validation list for each of the hyperlinks (programmatically), then in an adjacent column use the =Hyperlink formula to follow whichever one is chosen.
For example:
Thanks for the reply but that's not what I want to do for exemple I need to merge link from row 2,3,4 into one cell same for 5,6 into one cell and 7 to 12 into one cell is there a way to automate this I have a couple thousand to do
If you don't need to click on them to go to those URLs, and you just care about the text, then you can use this in row 1 and copy down
Formula:
=TEXTJOIN(",",TRUE,C1:Z1)
where C1:Z1 is the range of columns that could contain a URL. Use the row with the most URLs to set this range; blank ones will be ignored.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Simon133 
Register To Reply
Bookmarks