In Live datasheet can I get the required value from A1 to B1

[tv9_rohith]

In Live datasheet can I get the required value from A1 to B1

Here when ever I enter email address in A1 ,A2,A3.... then I only need the first half of the email ID in B1,B2,B3..........
for example :
A1
rohith@yahoo.com

B1 value should be
rohith

B1 Cell should exclude the value from "@" onwards...

Thanks,
Rohith M

 

[VoG]

Try

=LEFT(A1,FIND("@",A1)-1)