Thursday, December 12, 2013

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:

+ Get the left part of the string, myusername:

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

+ Get the right part of the string,

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