Try this in sheet2!B1

=CONCATENATE(Sheet1!A1,Sheet1!A2,Sheet1!A3,Sheet1! A4,Sheet1!A5,Sheet1!A6,Sheet1!A7,Sheet1!A8,Sheet1! A9,Sheet1!A10,)


regards


Rajesh Mehmi




"sam" wrote in message
...
Is is possible to display a value from a range in sheet1 in a cell in
Sheet2?

For eg:
In Sheet1, I can get a value in any cell between A1:A10 randomly, the
value
is a mix of Numbers and alphabers, such as A1i, C3e, D9f etc
And I want to display this value in Sheet2 Cell B1

So basically, Scan Sheet1-A1:A10 and locate a cell that has any value
displayed(Only one cell will display a value), then display that value in
Sheet2-B1

How can this be done?

Thanks in Advance.