Hi,

How can I combine the data (text & numbers) of various cells Say: Cell C1, C2, C3, C4, C5 into Cell C6?

For example:

C1= Quotation
C2= against
C3= No. 54125
C4= is not valid
C5= $50 to be paid.

C6= Quotation against No. 54125 is not valid $50 to be paid.

Thanks.