CALC hyperlink: adding file name from a cell into the path name

[jkmac]

Have have a path name in the URL field of a hyperlink. Using a path to a file works fine, but want to get the actual file name from a field in my spreadsheet.

This works but includes the file name explicitly. It just opens the file so I can see details.
file:///C:/Users/Fred/Documents/fred/Temp/Orders/SO_10001.ods

So want something like
file:///C:/Users/Fred/Documents/fred/Temp/Orders/A1

where A1 = SO_10001.ods

Have tried CONCAT() but either I am screwing up the syntax or it is just the wrong way to do it.

[erAck]

=HYPERLINK("file:///C:/Users/Fred/Documents/fred/Temp/Orders/" & A1)

or the same with CONCAT()

=HYPERLINK(CONCAT("file:///C:/Users/Fred/Documents/fred/Temp/Orders/";A1))

if you prefer.
See HYPERLINK() online help.
Ctrl+Click on the display string then opens the file as usual.

[jkmac]

erACK-
That’s the ticket!

My syntax was a mess even after spending hours with the User Guide.

Thanks…