try this formula
=MID(CELL("address",Sheet1!A1),FIND("]",CELL("address",Sheet1!A1))+1,99)&"
= "&Sheet1!A1
On Fri, Sep 3, 2010 at 6:08 AM, jjsmd wrote:
>
> Hi:
> I am new to excel and I was wondering hiw I would do the following.
> I have an excel worksheet with names of people in a sheet goin
Hi:
I am new to excel and I was wondering hiw I would do the following.
I have an excel worksheet with names of people in a sheet going from
column A to X and row 1 to 10.
I would like to get a worksheet showing the location and then name.
Ex: A1=John, A2=Smith and so on.
Is this easily done? a
