REGEX TO PARSE NUMBERS IN NON-STANDARDIZED TEXT

[Ewbkm]

I have input like this and need to extract LN# from each cell.  The number I need are after "LN".  I cannot figure out a Regex formula to parse the LN No out.  Please help.  Thanks.

Data:

SUNNY AVENUE INVESTMENTS, LLC  LN 31600003462, COVERING INSURANCE DEDUCTIBLE FOR LOAN COLLATERAL PROPERTY

CHURU INVESTMENTS, LLC  LN 816803472, COVERING INSURANCE DEDUCTIBLE FOR SBLC

HOPE PACIFIC 3900 LLC  LN 76962939  THIS SBLC IS AN APPROVAL CONDITION FOR LN 76962939

Expected Output:

LN No

31600003462

816803472

76962939

[binuacs]

@Ewbkm One way of doing this

[nagakavyasri · Accepted solution]

@Ewbkm : another way

[Ewbkm]

Thanks.  Your solution works.  However, I am not sure it's my data or something else.  With this REGEX formula applied to my data, it split out additional 30 fields before the last column, which the only one I need.  I attached the original data for you to try.  I know I can just use Select to choose the column I need to continue but just curious if there is any way we can parse without the blank columns?

Thanks..

[binuacs]

@Ewbkm Your Excel had so many blank columns and blank rows which were causing the issue, I deleted all the unwanted rows and columns and attached the workflow