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
Solved! Go to Solution.
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..
@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