Adding many cell values to the ends of each other

Hi, I am new to Excel; I know the basics, but this one has me stumped...

I want to be able to add 4 or 5 text-value cell together (Each one being added to the end of the previous) to make one large combined cell. For example, I want to do this:

If cell A1 = "I went"
cell B1 = "to the"
cell C1 = "store to"
cell D1 = "buy eggs."

I want Cell E1 to say: "I went to the store to buy eggs."

I need to have the same combining action for the other rows, which will have different text values in the cells, leading to the same combining result.

This seems difficult to me, but maybe some of these Excel masters can shed some light on this. Any/all help is greatly appreciated. Thanks!

-Evan

Hi Evan,

In E1 put this formula: =A1&" "&B1&" "&C1&" "&D1

then repicate down to the end of your range

Best regards

Wow that was fast; and a lot easier than I expected, thanks so much!

-Evan

Thank you Evan for your feedback, welcome to the forum, i learned many thingd here

Best regards