Microsoft Office Questions? Ask a IT Expert for Support ASAP
Hi there and welcome
Yes, you can use a formula for this.
in the cell you want this to display in enter the formula
=A1 & " " & B1 & " " & C1 & " " & D1 & " " & A2 & " " & B2
You can keep going as many as you wish. I put the " " in between so they have a space.
Then copy that cell down throughout all the rows you want to use it for.
If you have any problems, or would like any additional information or assistance, please do not hesitate to let me know.
Else if you can take a second to rate my service by clicking one of the stars at the top of the screen then submit, that would be greatly appreciated.