Extract LowerCase initials from name in single column

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

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

Find more posts tagged with

Formulas

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

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

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.

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

THANKS SO MUCH!!!

My formula is working like I need it to now.

Happy to help!

Dropdown list restrictions
Is there a way to limit a dropdown list so that the values in the dropdown list can only be used once in a column?
seeking VLOOKUP or equivalent, search for most recent value, multiple dropdowns
My product/use case: I seek to build a camera inventory. Each camera has a unique identifier. Cameras are mobilized to different locations on different days. I need help making a VLOOKUP or equivalent combination of formulae functions to run 2 queries cross-referencing 2 grids, searching a column with multiple dropdown…
Getting error message in approval email
Hey, Is anyone else facing this issue in the approval notifications sent through smartsheet