How to split full name in Zapier into first name and Last name

[@jeemon123]

This is a great tutuorial

[@damartech]

Thanks mate

[@damartech]

Thanks mate

[@damartech]

Thank you for your support and kind words! We appreciate your feedback and are glad to hear that you found the tutorial helpful.

[@silviacoto9630]

Thank you!

[@flowridge]

thank you brother

[@damartech]

Thanks mate

[@damartech]

Thanks mate

[@damartech]

Thank you for your support and kind words, we truly appreciate it!

[@s0cial_gamer]

how about to split them to columns instead of into rows in spreadsheet?

[@damartech]

Once you split the names, you can use google sheet add to a new row action to update the first and last name to each column, if that is what you were asking

[@kevy213]

Does this leave the last name field blank if there is only a first name and no last?

[@damartech]

This code will come into play
else {
lName = "'';
if it is a single name and empty space will be used. Hope this answers your question

[@kristyferguson5630]

Thank you!

[@damartech]

Thanks mate

[@damartech]

Thanks mate

[@damartech]

Thank you for your support! We appreciate your kind words.