Extraxct firat 4 characters from email address before . (dot)

[Howardc1001]

I would looking for a formula to extract the 1st 4 characters from a name in an email address before the . (dot)

I have attached sample data


Your assistance in this regard is most appreciated

[KOKOSEK]

Please Login or Register  to view this content.

[Pete_UK]

If you want to ensure that you are only looking at the characters before the first dot (even if there are fewer than 4), then you could use this:

=LEFT(LEFT(B1,FIND(".",B1)-1),4)

If you are sure there will always be at least 4 characters before the first dot, then you could use this:

=LEFT(B1,4)

Hope this helps.

Pete

[Howardc1001]

Thanks for the help Guys. Formula's works perfectly

[Pete_UK]

You're welcome, thanks for the rep.

Pete