Want a formula

 Trowa -

I want to get a text data of a perticular cell from sheet1 to a perticular cell in sheet2

1 reply

Go to sheet 2 and select your destination cell.
Then go to the formula bar (the long white bar on top of the sheet) and type "=".
Now go to sheet 1 and select you target cell and hit enter.
Select your destination cell again and check what excel added to the formula bar.

Best regards,