I have a spreadsheet with a bunch of numbers in one column. How can I use google sheets RIGHT formula to take the last 4 numbers and paste them into the adjacent column? I am trying to write a function in Google Apps Script for this. There isn't much documentation on this so I am lost.

5

1 Answer

Explanation:

  • One way to implement the RIGHT google sheets formula in google scripts is to get the desired value as a string and then use slice(-4) to get the last 4 digits of that number. Of course there are many ways to achieve the same goal but this is just one of them.

  • To get the value of a cell as a string, you can use getDisplayValue(). The following script will get the display value of cell A1 and it will set the value of B1 to the last 4 digits of cell A1.

Code snippet:

Feel free to modify the sheet name (in my case Sheet1) and the input and output cells (in my case A1 is the input and B1 is the output).

function myFunction() { const ss = SpreadsheetApp.getActive(); const sh = ss.getSheetByName('Sheet1'); const value = sh.getRange('A1').getDisplayValue(); const valueL4D = value.slice(-4); sh.getRange('B1').setValue(valueL4D); }

Input (A1) / Output (B1):

enter image description here

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password

Post as a guest

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.