how to retrieve cell contents from a row and combine them in a cell

[brianaclark1967]

Hi all,

I've attached a sample sheet

I have date in 6 cells in a row.

I want to add all the data together and repeat it in another cell combined)

Regards

Brian

 

[eibi]

I'd do it this way:

=D5&E5&F5&G5&H5&I5

But you can also:

=CONCATENATE(D5,E5,F5,G5,H5,I5)

Unfortunately, you can't =CONCATENATE(D5:I5) without some add-ins.