Excel consolidating data

[Danny]

I have a worksheet at the end of my spreadsheet which is
looking at previous spreadsheets and giving me a
consolidation. Is there a way that i can merge two cells
information from one worksheet into one cell in another.
I.e in worksheet1 i have cell A1 with the text 'Red' in it
and cell A2 with the text 'Fish' in it. On Worksheet2 i
want cell A1 to look up the contents of A1 and A2 on
Worksheet1 and display 'Red Fish'

Any ideas???

 

[Fred Davis]

Try in Worksheet2 A1
=Worksheet1!A1&" "&Worksheet1!A2

HTH,
Fred

 

[Danny]

Cheers Fred, this was spot on!

Danny.

-----Original Message-----
Try in Worksheet2 A1
=Worksheet1!A1&" "&Worksheet1!A2

HTH,
Fred
.