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
Bookmarks