Forum Discussion
Append portion of URL string into cells with existing file names to complete the string
I am trying to append a portion of a URL string to a column of cells, where there is already a file name.
I just want to add the URL path to the front of each file name in each cell so that each will become a working hyperlink. I've added the URL string to the front of several file names in cells manually
I was looking at formulas, but wondering A) am I making it too hard or B) is this possible to do?
Elementary/novice question most likely but thanks for any help!
3 Replies
- Thanks! No, I know that function. I have a spreadsheet given to me and in a column there is a file name (2000+). I know the URL to append to the front of each file name so that each will be a hyperlink. Each cell has a unique file name of course, I was hoping there was a way to select the cells in that column and add the rest of the path to its front end without touching each one individually. Hope that makes sense.
- You can use a helper column and concatenate both text values.
