EXCEL UDF with IF/ELSE

[Mikeyabosbht2021]

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?

 

[AliGW]

Cross-posted: https://www.ozgrid.com/forum/index.php?thread/1230272-excel-udf-with-if-else/

 

[vletm]

Mikeyabosbht2021
You should reread Forum Rules

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org

... and You'll soon remember clear sentences about Cross-posting.
Those rules are for You too.
HInt: Same kind of rules are in every Forum.

 

[KidneyStone]

Posted this solution at OzGrid, will only work if the text is formatted as in the example:

Function GetName3(target As String)
x = InStr(1, target, Chr(10))
If Left(target, 4) = "Dear" Then
GetName3 = Trim(Mid(target, 5, x - 5))
Else
GetName3 = Trim(Mid(target, 1, x - 1))
End If
End Function