not IsEmpty ( name ) ; Filter ( Proper ( name ) ; "ABCDEFGHIJKLMNOPQRSTUVWXYZ" ) ;
This will work if initials are w/o accents
Hey again Daniele,
I tried copying and pasting your formula but it's not working. I'm assuming I replace "name" with my field name but I keep getting "The specific field cannot be found". Here is my exact formula;
not IsEmpty ( Sales Associate ) ; Filter ( Proper ( Sales Associate ) ; "ABCDEFGHIJKLMNOPQRSTUVWXYZ" ) ;
The error seems to be highlighting the word "not".
Some times coping and pasting from this site brings with it some spurious invisible chars.
Try to enter the calc by hand.
Daniele, you are AWESOME!