Breaking News: Grepper is joining You.com. Read the official announcement!

excel text number with 12 characters in power querty

Open Oystercatcher answered on January 14, 2021 Popularity 1/10 Helpfulness 1/10

answer excel text number with 12 characters in power querty

excel text number with 12 characters in power querty

Comment

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.

Popularity 1/10 Helpfulness 1/10 Language whatever

Source: community.powerbi.com

Tags: excel text whatever

Link to this answer
Share Copy Link