Append to data

%3CLINGO-SUB%20id%3D%22lingo-sub-1969207%22%20slang%3D%22en-US%22%3EAppend%20to%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1969207%22%20slang%3D%22en-US%22%3E%3CP%20data-unlink%3D%22true%22%3EI%20have%20a%20field%20that%20is%20a%20store%20number.......12345%20%26nbsp%3B%20I%20need%20to%20add%20sa-s%20to%20the%20beginning%20and%20iPad%40domaindotcom%26nbsp%3B%26nbsp%3B%26nbsp%3Bto%20the%20end.%20%26nbsp%3B%20sa-s12345ipad%40domaindotcom%26nbsp%3B%26nbsp%3B%26nbsp%3B%20%26nbsp%3BHow%20can%20I%20accomplish%20this%3F%20%26nbsp%3BThanks%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1969207%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1969229%22%20slang%3D%22en-US%22%3ERe%3A%20Append%20to%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1969229%22%20slang%3D%22en-US%22%3EIf%20your%20store%20number%20is%20in%20cell%20A1%2C%20then%3A%3CBR%20%2F%3E%3D%22sa-s%22%26amp%3BA1%26amp%3B%22iPad%40domaindotcom%22%3C%2FLINGO-BODY%3E
Regular Visitor

I have a field that is a store number.......12345   I need to add sa-s to the beginning and iPad@domaindotcom   to the end.   sa-s12345ipad@domaindotcom     How can I accomplish this?  Thanks in advance.

1 Reply
If your store number is in cell A1, then:
="sa-s"&A1&"iPad@domaindotcom"