• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

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

B

brianaclark1967

Member
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
 

Attachments

  • formula query - for invoice rev 1.xlsx
    8.7 KB · Views: 7
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.
 
You must log in or register to reply here.
Back
Top