Need to the last 5 digits from IDs

Hi, I have an ecommerce store and so I am using the Stackby tool to manage the product inventory.

I have one column of PRODUCT ID consisting of 12 digits long code, I need to extract the last 5 digits out of it and want to put it in another column.

Can anyone tell me the correct formula for it?

Hi Yetrirej,

Please use the text formula function RIGHT() for it. It extracts how many characters are at the end of the string.

Screenshot 2022-07-18 at 1.15.23 PM

So the right formula for your above use-case is:


Hope this helps,