How to reference another sheet using =left formula????? Help

[Caveman1964]

Hi,
I have the formula for left function but I need to reference another worksheet.
=left(e1,find("@",e1)-1) however, e1 is on sheet3 and this formula will be on sheet 2.

Any help is appreciated.
Thanks

 

[arthurbr]

Perhaps =left(sheet3!e1,find("@",sheet3!e1)-1)

 

[Tetra201]

Try

=LEFT('Sheet 3'!E1,FIND("@",'Sheet 3'!E1)-1)

 

[Caveman1964]

Try

=LEFT('Sheet 3'!E1,FIND("@",'Sheet 3'!E1)-1)

Works! thanks guys!