Problem with Splitting of names
Status: Closed · Asked by quepreonpay on · 0 views
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
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