Need to the last 5 digits from IDs

[Yetrirej]

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?

[rachitk]

Hi Yetrirej,

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

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

RIGHT({PRODUCT ID}, 5)

Hope this helps,
Rachit