truncate last name to first initial regardless of length

[opusarlo]

As you can see I have quite a resource heavy process for taking names from the top sheet to the end sheets in order to organize them alphabetically by last name. I recently have learned that I need to further customize the output to display only first names and last initials. On the tab titled "night charge" you will see the top name is listed as "disco duck". I need this to change to "disco d". I can have as many columns as I need because I will simply hide the extras when it comes time to print. I would like to do this on: all three team sheets, day, eve, night, as well as the night charge and night second sheet. Is there a way to take the populated name and truncate it to first name last initial? Incidentally the first 2 columns on the team sheets and the last 2 sheets look different because they will be hidden in the final project.

[alansidman]

In V4 =LEFT(C4,FIND(" ",C4))&" "&MID(C4,FIND(" ",C4)*1,2)

and copy down.