Would you like to separate the column in your spreadsheet that consists of the full names of people into first and last names? Well then, stick this very simple script to your spreadsheets apps script editor and you'll be able to do just that. Split The Selected Column The following script will do three things: bound Create a custom menu in your spreadsheets tabs with the title . Custom Menu After you call select the custom menu, It will check the to split into. The script won't work if you don't select a cell in the right column. cell you've selected Separate the whole column into two columns, with the first value in the first column and the second(& rest if there are any) in the new column. function splitName() {
// get sheet and data
const sheet = SpreadsheetApp.getActiveSheet();
// get selected row
const activeColIndex = sheet.getActiveRange().getColumn();

const data = sheet.getDataRange().getValues();
const lastRow = data.length;

sheet.getRange(1,activeColIndex,lastRow,1).splitTextToColumns();

}

// if you're new and only want this feature the use this code
/**

OnOpen trigger that creates menu

@param {Dictionary} e
*/
function onOpen(e) {
createCustomMenu();
}

/**

Menu creates menu UI in spreadsheet.
*/
function createCustomMenu() {
let menu = SpreadsheetApp.getUi().createMenu("Custom Menu"); // Or DocumentApp or SlidesApp or FormApp.

menu.addItem("Split Names", "splitName");
menu.addToUi();
}

/**

Code By Nibesh Khadka.

I am freelance and Google Workspace Automation Expert.

You can find me on:

https://linkedin.com/in/nibesh-khadka

https://nibeshkhadka.com

me@nibeshkhadka.com
*/ How To Add Apps Script Code To a Spreadsheet If you don't know how to add this script to your sheet, then just click the tab and then as shown in the image below. Extensions Apps Script Now, similar to the , you can now just: previous blogs Save the code. Reload the document. Where you'll see the custom menu as shown below And execute the function. Executing The Function Here are a few images to guide what the operation will look like in your docs. Thank You for Your Time My name is Nibesh Khadka, and as a freelance automation expert, I specialize in automating Google products with Apps Script. So let's get started! If you need my services let me . know Don’t forget to like and share this blog. Also published . here

The code in this story is for educational purposes. The readers are solely responsible for whatever they build with it.

2022 - Tech Tutorial Teacher of the Year

Subscribe To Our News Letter For Free Contents

Hire Me

Newsletter

Buy Me a Coffee

Nominated for 2022 - Tech Tutorial Teacher of the Year

Developer 

Too Long; Didn't Read

In your car, at home, or at work — Bosch technology shapes many areas of life.

Use This Script to Separate the First and Last names in Google Sheets

Too Long; Didn't Read

People Mentioned

Khadka's Coding Lounge.

STORY’S CREDIBILITY

Code License

About Author

TOPICS

THIS ARTICLE WAS FEATURED IN...

Use This Script to Separate the First and Last names in Google Sheets

Too Long; Didn't Read

People Mentioned

Khadka's Coding Lounge.

STORY’S CREDIBILITY

Code License

About Author

TOPICS

THIS ARTICLE WAS FEATURED IN...

RELATED STORIES