Tuesday, January 12, 2016

yogi_Convert An Array Of Names Into UserNames (lowercase without any special characters)

Google Spreadsheet   Post  #2015
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-12-2016
post by: Robert Andrews:
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/TD8PeY05ufo;context-place=mydiscussions
Convert name to username?
How can I take a cell containing a full name and turn it in to a username - ie. no symbols or spaces, only text, preferably lower case?

Remember, names come in all shapes and sizes, with punctuation marks, middle names, spaces and all sorts.

Thanks.
----------------------------------------------------------------------------------------