excel text number with 12 characters in power querty code example

Example: 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.