Link to home
Start Free TrialLog in
Avatar of Andreas Hermle
Andreas HermleFlag for Germany

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
Avatar of Rory Archibald
Rory Archibald
Flag of United Kingdom of Great Britain and Northern Ireland image

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

Avatar of als315
Flag of Russian Federation image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Andreas Hermle


Hi als315, great job, thank you very much for your professional help. I really appreciate it. Thank you very much.
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