I've converted my list-user field to text using the UserListToNames function. Now, I want to pull out the first and last initial for each user. So when I get the results "John Smith; Bob Jones; Robert Green" I want to convert that to "JS, BJ, RG". How can I do this?
With each row you add, you need to increase the first number by 1. See the bolded 4's above. Also note, each row would require a comma after it except for the very last one. (See the first two rows end with: )),1), and the last row ends with )),1)