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.
1 Answer
Explanation:
One way to implement the
RIGHTgoogle sheets formula in google scripts is to get the desired value as a string and then use slice(-4) to get the last4digits 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
A1and it will set the value ofB1to the last 4 digits of cellA1.
