Search code examples
google-sheetsstring-concatenation

Google Sheets: "Bob Smith" --> "bsmith" formula?

I'm trying to pull data from another Google Sheet to feed another Google Sheet. I need to pull from a full name field, which will have something like, "Bob Smith" and then I need to have it rewrite into the new Google Sheet as "bsmith".

Basically, "Get first letter of the first string, then concatenate the entire second string, and then make all lowercase."

So far I've gotten =LEFT(A28,1) working to grab the first letter of a string, but then not sure how to grab the second word and then concatenate.

Solution

  • To get the 2nd word you need to FIND() the first space then read from that position + 1 to the end of the string using MID(). & is used for concatenation.

    =lower(left(A28,1) & mid(A28, find(" ", A28) + 1, len(A28)))