Excel - Split string by a delimiter

To split a string by a delimiter (for example: "@") using the following function:

For example, we have a string at Cell #A2:

myusername@mydomain.com


+ Get the left part of the string, myusername:

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

+ Get the right part of the string, mydomain.com:

=RIGHT(A2, LEN(A2) - FIND("@", A2))





Comments