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 ...
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.