Excel: Adding cell contents after file path

[joey1211]

I have a folder containing book covers named using their ISBN code. In Excel I have a column containing these ISBN codes. I need to add these ISBN codes into another column which has the file path of the folder containing the covers.

ISBN Covers
AAA C:\Covers\AAA.jpg
BBB C:\Covers\BBB.jpg
CCC C:\Covers\CCC.jpg

Any ideas?

 

[joey1211]

Many thanks Greboth, worked like a charm.

Is it also possible to add some characters into each colums so that you can use them for formatting purposes in InDesign? So, in front of all the authors I would like $1$, in front of all the book titles $2$ etc.

 

[joey1211]

Method 1 in the following link has worked for the authors and titles but using it for the price delete's the pound sign.

https://www.extendoffice.com/documents/excel/670-excel-add-text-to-beginning-end-of-cell.html

I can overcome the £ disappearing by replacing the $2$ attributed to it with a $ sign in InDesign.

Is it possible to save the Excel spreadsheet to a text file without the columns that don't have $ signs in them? I cant delete the original column as it disappears from the formatted one. Is it possible to convert the imported text into actual text if that makes sense. Allowing me to delete the column without $ signs?