Concatenate would work. Or you can concat using an ampersand between text phrases phrase & phrase as outlined in the example below. You should also be escaping the quote characters with a backslash \" beforehand since they’re special characters.
So your formula will probably look something like:
@Jenn_Iannaconi That’ll be a bit more difficult, but still very much possible. If you can manage to extract the URL via a formula, then you should be able to use it in the Button field’s configuration settings to open the URL. Instead of concatenating you’d be combining a few formulas - such as MID, FIND or others. The formulas would be nested (so FIND could be inside MID for example). If you’re having trouble, make a separate post describing your progress and I’m sure someone will jump in to help.