Splitting Full Name into First Name and Last Name

Status: Closed · Asked by infoTP on · 0 views

infoTP — Question ·

Pabbly spreadsheet formulas don't seem to allow use of items like IFERROR and COUNTIF making it very difficult to work with entries which have only first name i.e. no space in full name. Have even tried using countif to check for no spaces - nothing seems to work. Any help would be appreciated.

The goal is to send first name only if there is only 1 word given in full name field and pass blank value in Last Name field. Examples of possible name combos are:

Sundeep Jain
Sundeep
Sundeep M Jain

Thanks

Fagun Shah — Reply ·

Back to all forum threads · Log in to reply