I must, after pasting a long list of patient names, truncate to display only the first two letters of the last name, for privacy.
Beethoven, Ludwig V must become Be., Ludwig V
Doe, Jane X must become Do., Jane X
I've been using this:
=(LEFT(D66,2)&"."&","&(RIGHT(<wbr style="color: rgb(34...