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
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/); B:(XXXXX); C:(yadayada) and then combine them into a single string in D. Is there a way to do that?
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”.
(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
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)