Extract LowerCase initials from name in single column

TTraylor

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

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

 

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

Mike Wilday

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

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

TTraylor

THANKS SO MUCH!!!

 

My  formula is working like I need it to now.

Paul Newcome

Happy to help!