How to create formula for initials with numbers

Screenshot is attached. I need the first column with the names for example Thiele, Greg. To be read GTHIELE and the appointment id after that all connected. In the end itll look like this for example on row one. GTHIELE945275144

Got it figured out! It was LEFT(RIGHT({Name},MINUS(LEN({Name}),SEARCH(" “,{Name},1))),1) & regexextract({Name},”[\w]*") & {APPOINTMENT ID}