Andreas Hermle

asked on

# Extract a substring from a string in excel using a formula

Dear Experts:

I would like to automatically extract the substring **L=xxcm (or L=xxmm)** from strings in Column A using a formula. I could you use the TEXT-TO-COLUMNS functionality, I know but I wonder if a formula could also produce a result.

The substring, L=xxcm, or LL=xxmm (e.g. L=88cm) can occur in all positions, even at the beginning.

Help is much appreciated. Thank you very much in advance.

Regards, Andreas

Linos L=30cm sharp blunt |

Linos sharp blunt neutral L=30mm sharp blunt |

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

Hi als315, great job, thank you very much for your professional help. I really appreciate it. Thank you very much.

ASKER

H Rory, I work on Excel 365, thus I got all the latest formulas. In this case I will take a deeper look into these new text functions. Thank you very much for it.

Regards, Andreas

Regards, Andreas

Which version of Excel do you have? Do you have the TEXTSPLIT function?