extracting text before first space

[howard]

I would like a formula to extract the text before the first the . (dot) in an email address that is in A4

eg alan.james@gmail.com

I know how to use = Left(A4,4) , but if the name was for eg Stuart it would be incorrect. I need to extract the name before the first dot


It would be appreciated if someone could kindly assist me

 

[Jonmo1]

Try

=LEFT(A4,FIND(".",A4)-1)

 

[Mike LH]

Hi,

=TRIM(MID(SUBSTITUTE("." & A2&REPT(" ",6),".",REPT(" ",255)),1*255,255))

 

[howard]

Thanks for all the help, much appreciated

 

[Jonmo1]

You're welcome.