i was wondering if there is a way to take a range of cells and turn them into a string with the same string between each cell value. i realize this is a rather easy thing to do in code, but is there a way to do it live on the sheet?

example

    A       B
1  "a"    " f "
2  "b"
3  "c"
4  "d"
take colume A and combind with B1 as the spacer resulting the the string "a f b f c f d"