adding a string prefix/suffix to a cell

I have this string in A1: www.example.com

Now I want to make A2 the same as A1, except I want to add text to both the beginning and the end of it so it reads: http://www.example.com/test

I'm just learning Excel so bear with me, but I imagine A2 would be something like: "http://" + (A1) + "/test" , but obviously I am not familiar enough with Excel's syntax yet.

Thanks for the help!

I could not read your examples but I suppose you are trying to concatenate.
This would the be someting like ="http://"&a1&"yourtext"

if cell A1 = cat and cell B1 = dog

in cell C1 type =concatenate(A1,B1) and you get catdog

in cell D1 type =concatenate("thin ",A1," and fat ",B1) you get
thin cat and fat dog

Originally Posted by arthurbr

I could not read your examples but I suppose you are trying to concatenate.
This would the be someting like ="http://"&a1&"yourtext"

That is exactly it! Thank you for your help. I was just trying to use + to concatenate instead of &.

You're welcome