Interesting Text Calculation
I have a pretty complicated calculation I've been working on and now I'm at the step where I have to pull the first initials of a persons first and last names. The name field is simply a value list drop down box of employees. For example, John Smith. How do I pull "JS" in my calculation? Not sure if this is even possible.
Also, if blank (the default), how do I populate it with "XX" in my calculation?