Concatenate

N

Nicawette

Dear all,

I have excel 2007 and I would like to concatenate the cells C8 to J8
of sheet1 in sheet2.

=CONCATENATE('sheet1'!C8:J8)

If I insert this formula in column H of sheet2, excel displays only
the value of cell H8 of the sheet1
If I insert this formula in column E of sheet2, excel displays only
the value of cell E8 of the sheet1
If I insert this formula in different column than the column C to J of
sheet2, it displays #Value

any Idea to have the cells concatenated correctly?

Thank you

Nico
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with a VBA subroutine 0
How Do I Avoid #REF! In Formulas? 5
Dealing with the error: unable to filter on excel hc home school 0
HELP: IF Statement between Dates for Reverse Index failing 0
If function across sheets prints value of cell 4
Lookup function to return highest value 4
Index Match to ignore blank cells 0
if statement, change cell only if true 4

Top