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
take colume A and combind with B1 as the spacer resulting the the string "a f b f c f d"Code:A B
1 "a" " f "
2 "b"
3 "c"
4 "d"