Problem with Splitting of names

When we have an 2 Names( Example: Suman N) that is First Name and Second name we were using Split Text formula To get successful response that is (Suman + N).
Then if a person doesn't have second name then we used Spread Sheet formula to get response as NA ( IF(LEN('2. Result 2 : Madappady')=0,'NA','2. Result 2 : Madappady') .

But in the case of Three Names Splits what should if a person doesn't have second name and last name??
if a person name is Dr Sajjan Madapaddy how to make this please guide us with an example?????
 

Attachments

  • 01.png
    01.png
    34.5 KB · Views: 160

Hermes

Active member
Best is a router, with route 1 is that if result0 = Dr or Drs or Mr or anything you could think of, then add result1 as surname.
With a router you could add all possibilities, if 1 still now correct just add it to the router and re-execute
 
Top