Extract LowerCase initials from name in single column

TTraylor · 07/08/19

Need to get correct formula/function to execute the following:

PREFIX: PKS-

Name Column: JOHN DOE

ID Column: 00123456

Desired Formula Output: PKS-jd-00123456

Here is what I have currently:

="PKS-" + LOWER(Name204) + "-" + ID204 and the output is: PKS-john doe-00123456

OR

="PKS-" + LOWER(LEFT(Name204) + "-" + ID204) and the output is PKS-j-00123456

Paul Newcome · 07/08/19

Try using a FIND function within MID function to pull the letter after the space...

=LOWER(MID(Name204, FIND(" ", Name204) + 1, 1))

Mike Wilday · 07/08/19

Yep. Do what Paul is suggesting and add that after the lower left with a + sign and you should get what you're looking for.

="PKS-" + LOWER(LEFT(Name@row) + LOWER(MID(Name@row, FIND(" ", Name@row) + 1, 1)) + "-" + ID@row)

Here is the whole formula in one. I also had to add the quotes around the ID204.

Mike Wilday · 07/08/19

Scratch that last bit about the quotes. That was a mistake.

TTraylor · 07/08/19

THANKS SO MUCH!!!

My formula is working like I need it to now.

Paul Newcome · 07/08/19

Happy to help!

Comments