excel text number with 12 characters in power querty
Go to edit queries,
1. Add column->Format->Add Preifx, enter 00000000
15.png
2. click on "Prefix" column, Add column->Extact->last characters, enter count = 4
3. click on"Last Characters" column, Add column->Extact->first characters, enter count = 1
4.Add column->add conditioanl column
16.png
5. click on "number" column, Add column->Extact->length
6.click on "condition1" and "Last Characters" columns, Add column->merge columns
7.add conditional column
17.png
Finally, you could remove other columns, only keep "number" and "condition2" column.