display a value from Sheet1-A1:A10 in Sheet2-B1

[sam]

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.

 

[Pete_UK]

If all but one cell is blank, then you can do this:

=Sheet1!A1&Sheet1!A2&Sheet1!A3 ... etc to ... &Sheet1!A10

Hope this helps.

Pete

 

[Rajesh Mehmi]

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

(e-mail address removed)