Concatenating fields

[Dorlene]

Please help! One column contains a list of URLs, e.g,
http://cookingcareer.shawguides.com/schoolname. I want to
append the same text (/secure) to each one of these URLs
so that I can add a column with URLs that have /secure
appended to them, e.g.,
http://cookingcareer.shawguides.com/schoolname/secure.
Any help you can provide is greatly appreciated!

 

[Frank Kabel]

Hi
try in a helper column
=HYPERLINK(A1&"/secure")

 

[Frank Kabel]

Hi
try in a helper column
=HYPERLINK(A1&"/secure")

 

[mzehr]

Hi,
Assuming that your URL is in column A use the following in
column B:
=Hyperlink(A1&"/secure")
you will need to copy the formula down

HTH