examples…
=LEFT(H3,FIND(“@”,H3)-1)
to retrieve the username portion of an email address (anything before the @)

=LOWER(LEFT(B2,6)&LEFT(C2,1))
grab the first 6 characters from cell b2 and concatenate w/ the first character from cell c2. then lowercase.

using Data->Filter from within excel is also very useful

source:
http://chandoo.org/wp/2010/01/19/usernames-from-email-formulas/

removing duplicate rows:
do a find and replace and use find all, then select all of the results and choose delete -> delete sheet rows on the ribbon bar.

source: http://blog.contextures.com/archives/2010/06/21/fast-way-to-find-and-delete-excel-rows/

Comments are closed.