SPLITNAMES (First, Middle, Last) User Defined Function in Google Sheets, Dynamic Arrays & JavaScript

Learn how to create user defined functions in Google Sheets that return dynamic arrays.
We'll create SPLITNAMES UDF (user defined function) using JavaScript & Apps Script that will separate first, middle initial & last names to their respective columns.

#udf #gsuite #function

[Di_Sky]

Отлично! Опять узнал что-то новое! Спасибо🔥

[rodrigosanchezdelrio]

Great vídeo. Can you do a AppSheet series? Thanks.

[findthetruth]

Could you please make a video on how to link excel online to google sheets and update the records live. Thanks in advance.

[srelck]

Wow, this is way better than using insanely convoluted ArrayFormula() formulas. What happens when you overwrite a cell value that's returned by this custom function, do you get a reference error like you do with array formulas?

[sarcopter]

Hi! you need to use 'const'' declaration instead 'let' because have no changes inside map loop

[simonweller]

I got the same as Inge W people.map is not a function

[ingewll]

What do I do wrong here?

1 function SPLITNAMES (people) {

2

3 let nameParts, fn, mn, In

4

5 return people.map(person => {

6 nameParts = person[0].split(" ")

7 1f(nameParts. length >= 3){

8 //first, middle, last name

9 [fn, mn, ...In] = nameParts

10 return [fn, mn, In.join(" ")]

11 }// close if 3

12


Execution log

18:69:46 PH Notice Execution started

18:69:47 PH Error TypeError: Cannot read property ‘map’ of undefined
SPLITNAMES @ Code gs’5