**** For Office 365 users, the following formula is much simpler:

=LEFT(TEXTAFTER([@[Sales Representative]], " ", , ,1) )

Learn how to tame Slicers with too many buttons to fit on the screen using what's known as an Initialization Slicer.

File Download Link:
https://www.bcti.com/wpcontent/YT_Do...

The formula for extracting the first character from the last name:

=MID([@[ColumnName]], FIND("/", SUBSTITUTE([@[ColumnName]], " ", "/", LEN([@[ColumnName]])LEN(SUBSTITUTE([@[ColumnName]], " ", "") ) ) ) + 1, 1)

Explanation of formula:
https://spreadsheetplanet.com/findla...