Trim, length and text to figure

Maybe not the most sexy solution (or at all), but you could try the following:

1) Split the column at each occurence of SPACE

2) Replace .(dot) with ,(comma) in the column that end up containing for example 2.5

3) Create a Custom Column with the following M expression --> [DN]&" "&[2,5] --> DN and 2,5 must be replaced with the name of the column containing these values

This is based on the assumption that your uotput should be like the column to the right, and the format before / is the same for all rows.

Try the following:

1) Select column DN

2) In 'Add Column' tab, press 'Column From Examples'

3) Start typing DN 1200 in the first row, it should suggest Text Before Delimiter transformation, if not move to second row and type it again

4) Press OK, it should generate following formula (#"Changed Type" is previous step name, most likely will be different in your case):

= Table.AddColumn(#"Changed Type", "Text Before Delimiter", each Text.BeforeDelimiter([DN], " ", 1), type text)

 5) Select the new column, go to Transform tab and use Replace Values to convert '.' to ','

Orstenpowers  here's what i would do:

1. Right click on the column, replace values to replace "." with ","
2. Right click on the column, replace " /" (space and /) with "*/" (asterisk)
3. Right click on the column>>Split column by delimiter>>at the first occurrence using */ as the delimiter.
4. Right click on the column, replace "*" with nothing.

If this answers your question, kindly mark as solution.

= Table.AddColumn(Source,"extract", each Text.Combine(List.FirstN(Splitter.SplitTextByWhitespace()([txt]),2)," "))

See if my code works