Hi, i am looking to extract the last word in an array. Sometime it will be the second word and other time the third word.
Clients who have middle names i will need the third word and for clients who have no middle name i will need the second word.
I need to extract the surname from the cell. pleasee see below
i have been able to the first part of the process in matching the first name initial from the cell to the webpage but i have no idea how i can do this with the surname. With the surname i will need to match the surname exactly unlike the first name where we are only matching the initial.
Below is a screen shot of my current workflow for this particular check