need your assistance on creating formula to get specific number in cells.
Currently i have many rows,
please see sample below, each id has 11 characters and can be start with 10000 or 20000
ID (expected result)
please use this id 10000428271 to fix this issue...