• Instructions to Ask a Question

    For any assistance, please click the "Ask a Question" button and select the Pabbly product for which you require support.

    We offer seven comprehensive applications designed to help you efficiently manage and grow your business:

    Our support team endeavors to respond within 24 business hours (Monday to Friday, 10:00 AM to 6:00 PM IST). We appreciate your understanding and patience.

    🚀 Exclusive Lifetime Offers 🚀

    We invite you to take advantage of our special one-time payment plans, providing lifetime access to select applications:

    • 🔥 Pabbly Connect — Lifetime Access for $249View Offer
    • 🔥 Pabbly Subscription Billing — Lifetime Access for $249View Offer
    • 🔥 Pabbly Chatflow — Lifetime Access for $249View Offer

    Make a one-time investment and enjoy the advantages of robust business management tools for years to come.

  • Due to Diwali and Bhai Dooj celebrations, our team will have limited availability. While we’ll continue to monitor threads, responses may be slightly delayed. Normal operations will resume on Friday, 24th October 2025.

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: 151

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