# EXCEL Help once again. Updating a list to include data from each cell in a hyperlink **URL:** \ **Category:** Factual Questions\ **Created:** [April 22, 2025, 3:18am UTC](https://boards.straightdope.com/t/excel-help-once-again-updating-a-list-to-include-data-from-each-cell-in-a-hyperlink/1017344 "2025-04-22T03:18:32Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Bear\_Nenno](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/bear_nenno/32/3358_2.png) [@Bear\_Nenno](https://boards.straightdope.com/u/Bear_Nenno)\ **Post date:** [April 22, 2025, 3:18am UTC](https://boards.straightdope.com/t/excel-help-once-again-updating-a-list-to-include-data-from-each-cell-in-a-hyperlink/1017344/1 "2025-04-22T03:18:32Z")
What’s the fastest way to do this? Bonus points if it can be done without a script. I have a list in Column A. Suppose each cell in that column has a random 5 digit number. In Column B, I’d like to have a hyperlink string that incorporates whatever is in Column A. So, if A is 22556 23664 87245 Then I want to create Column B as quickly and easily as possible, such that Column B is now: [www.blablabla.com/22556/yadayada](http://www.blablabla.com/22556/yadayada) [www.blablabla.com/23664/yadayada](http://www.blablabla.com/23664/yadayada) [www.blablabla.com/87245/yadayada](http://www.blablabla.com/87245/yadayada) Other than the numbers, the link text will always be the same. The numbers will go in the same place in each. If there is some feature that does the opposite of “Text to Columns”, this would work for me. I could make three columns: A:([www.blablabla.com/](http://www.blablabla.com/)); B:(XXXXX); C:(yadayada) and then combine them into a single string in D. Is there a way to do that? ---
**Author:** ![Reply](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/reply/32/15952_2.png) [@Reply](https://boards.straightdope.com/u/Reply)\ **Post date:** [April 22, 2025, 3:59am UTC](https://boards.straightdope.com/t/excel-help-once-again-updating-a-list-to-include-data-from-each-cell-in-a-hyperlink/1017344/2 "2025-04-22T03:59:28Z")
You’d just use the `&` operator to “[concatenate](https://support.microsoft.com/en-us/office/concatenate-function-8f8ae884-2ca8-4f7a-b093-75d702bea31d)” the strings together, like this: `=HYPERLINK("https://www.blablabla.com/" & A1 & "/yadayada")` Where `A1` is `22556`. You can drag that down all of column B and it’ll work the way you want. Concatenate is just a fancy word for “joining together pieces of text”. Online example: [Hyperlink example in Excel online](https://1drv.ms/x/c/9867ed46f373003e/Ef0goWEAAGJAghzn9JcBgZMB1QsD1e_JPIAkScgApu6LgQ?e=de0lQo) ---
**Author:** ![Bear\_Nenno](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/bear_nenno/32/3358_2.png) [@Bear\_Nenno](https://boards.straightdope.com/u/Bear_Nenno)\ **Post date:** [April 22, 2025, 4:02am UTC](https://boards.straightdope.com/t/excel-help-once-again-updating-a-list-to-include-data-from-each-cell-in-a-hyperlink/1017344/3 "2025-04-22T04:02:33Z")
Nailed it. Thanks!!! ---
**Author:** ![Whack-a-Mole](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/whack-a-mole/32/141_2.png) [@Whack-a-Mole](https://boards.straightdope.com/u/Whack-a-Mole)\ **Post date:** [April 22, 2025, 4:05am UTC](https://boards.straightdope.com/t/excel-help-once-again-updating-a-list-to-include-data-from-each-cell-in-a-hyperlink/1017344/4 "2025-04-22T04:05:05Z")
Not sure what I wrote would work. Already answered above. ---
**Author:** ![Reply](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/reply/32/15952_2.png) [@Reply](https://boards.straightdope.com/u/Reply)\ **Post date:** [April 22, 2025, 4:13am UTC](https://boards.straightdope.com/t/excel-help-once-again-updating-a-list-to-include-data-from-each-cell-in-a-hyperlink/1017344/5 "2025-04-22T04:13:35Z")
(Before @Whack-a-Mole edited away his initial reply) The `TEXTJOIN()` function is great for more powerful operations where you are working with entire ranges of text in the sheet, and/or want to use a “delimiter” character to separate them: [TEXTJOIN function - Microsoft Support](https://support.microsoft.com/en-us/office/textjoin-function-357b449a-ec91-49d0-80c3-0e8fc845691c) But it’s probably overkill for a simple concatenate. The `&` operator is just a shorthand (since it’s such a common operation). The fully written-out function version of it would be `=CONCATENATE("https://blablah.com", A1, "/yadayada")`, which does the same thing. The `HYPERLINK()` around either version just makes the link actually clickable. (Excel might auto-detect it as a link anyway, not sure)