add value to existing numbers

[Anonymous]

Hello,

Column in a table has 7 or more digits
I would like to add the value 8 to the beginning of the 7 digit numbers only
What is th ebest way to do this please?

[VijayP · Accepted solution]

if Text.Length([text])>=7 then [text]&"a" else [text]

Here [text] is the column(Field) and "a" is the text What i want to add

In power Query Editor , under AddColumn Tab, use Custom Column option to achieve this

---

@Anonymous wrote:

Hello,

Column in a table has 7 or more digits
I would like to add the value 8 to the beginning of the 7 digit numbers only
What is th ebest way to do this please?

---