Powey Query - Extract Text

[AllisterB]

HI

I need to extract the Age of people. the age occurs after the colon.

Blank Rows can be ignored but rows with text prior to the colon need to be included.

The result I want with blank rows is shown

Would I use a split in a Custom Column?

Thank you

Allister

[AliGW]

Just duplicate the column, extract after the delimiter (colon) and then trim the leading spaces.

M Code:

Please Login or Register  to view this content.

[Haluk]

Or, use a formula like this;

Please Login or Register  to view this content.

You may need to change the semicolons to comma depending on your version of MS Excel. 📌

[AliGW]

Except the OP explicitly requested a PQ solution ...