How to append a text string to cell content?

[RetroMunky]

Evening,

I have a spreadsheet containing 700 lines. One of the columns contains a file path text string (/images/example.jpg) and I need to append a web address to this string (www.example.com) so that each becomes (www.example.com/images/example.jpg)


I'm sure this must be possible, but to be honest I have had very little Excel experience. My background, whilst technical, is network infrastructure.


Thanks in advance for any suggestions.

Marc

Apologies, should have said that it is purely text - I'm not using hyperlink formatting in the spreadsheet as the intention is to save as a csv file.

 

[mvptomlinson]

Hi Marc,

If all of your file path text strings are in A1:A700, then in B1 use:

="www.example.com"&A1

Fill that down to B700. (If you double-click on the lower-right corner of cell B1, it will auto-fill down for you!)

 

[RetroMunky]

Absolutely spot on, thanks.