Mikeyabosbht2021
New Member
Hi Guys,
I have created two separate UDF in VBA that parse the "Dear" and "Your / To" from a block of text to leave just the forename and surname. Unfortunately, they are separate.
I am looking to create one UDF with IF ELSE so it returns the forename and surname when it finds either "To" or "Your" based on the one custom UDF.
Is that possible?
I have created two separate UDF in VBA that parse the "Dear" and "Your / To" from a block of text to leave just the forename and surname. Unfortunately, they are separate.
I am looking to create one UDF with IF ELSE so it returns the forename and surname when it finds either "To" or "Your" based on the one custom UDF.
Is that possible?