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}