I have an Excel database which has a hyperlink to a related form for each row
of data.
Each link is to a unique file.
Right now the hyperlink is in column J and the file name is in column K.
So the hyperlink column reads =hyperlink(K1,"File info") and so on.
It works nicely but I'm using two columns for a one column job.

I would like to combine the two columns into one, if possible. So that the
hyperlink would include the actual file path and name and not just the column
reference.

I have tried using a replace command and a concatenate command to try to
combine the two columns into one but neither works.

Any ideas?