Delete text from coulumn with both int and text in it

[Ludvig]

Hi!

I have a simple, but as it seems, hard problem for me to solve. As you can see in the pictrue so what i want to do is just to get rid of the "Sum=" but still have the value left, so the column should be [ 907; 22; 929] in this example, i have tried the M-code as you can see but it throws error regarding the problem of convertion from the values to Text. I will use these column as whole numbers and do some calculations on them.

Thanks in advance for all the help!

[BA_Pete · Accepted solution]

Hi @Ludvig ,

Try this::

Number.From(
    Text.Select(
        Text.From([Alla arenden]),
        {"0".."9"}
    )
)

Pete

[Ludvig]

Works like a dream! Thanks @BA_Pete my life just got a bit easier 😀