Check cell value based on columns

Learning Initatives Automation Starter
3

Hi @Reni_Sweta,

You can test the following to get what you want.

value = 1312313123131
value = if(value.Length>12,value.Substring(value.Length-12,12),value)

Regards,
MY