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.

How to Delete Empty Rows and Columns in Google Sheets

How to Copy a Column From One Sheet to Another in Google Sheets Easily 

Subscribe To Our News Letter For Free Contents

Hire Me

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

About Author

Comments

TOPICS

THIS ARTICLE WAS FEATURED IN

Related Stories

Access User Location with Permission Handler in Flutter

10 Indications That You Should Invest in Automation Via APIs

10 Commandments for AI-Assisted Social Media Marketers

11 Best Automation Testing Tools to Try in 2021

12 Use Cases of AI and Machine Learning In Finance

12 Ways You Can Use Email to Nurture Leads to Conversion

Access User Location with Permission Handler in Flutter

10 Indications That You Should Invest in Automation Via APIs

10 Commandments for AI-Assisted Social Media Marketers

11 Best Automation Testing Tools to Try in 2021

12 Use Cases of AI and Machine Learning In Finance

12 Ways You Can Use Email to Nurture Leads to Conversion

Light-Mode

Classic

Newspaper

Minty

Dark-Mode

Neon Noir

Minty

HN StartUps