I am trying to combine sentences from various cells into one cell. Example:

A1 - "hello"  

A2 - "how are"  

A3 - "you"

A4 - =combine(A1:A3) ---- > "hello how are you"

I know this trick: `=A1 & " " & A2.....` but I have 700 cells to combine into a single cell and this approach seems barbaric. If there is a built in function, that would be ideal. I don't mind an answer in VBA as long as the answer is extremely detailed starting with how to open VBA, as I do not know VBA.