Forum Discussion
Solved
Extract all consecutive 3-letter strings from text cell
I need a formula to extract all consecutive 3-letter strings from cells with varying lengths of text, then aggregate them, separated by slashes. In the example below, the column on the left is the da...
- =TEXTJOIN("/",,LOWER(MID(SUBSTITUTE(A1," ",""),ROW(INDIRECT("1:"&LEN(SUBSTITUTE(A1," ",""))-2)),3)))
**You can change A1 as you need.
=TEXTJOIN("/",,LOWER(MID(SUBSTITUTE(A1," ",""),ROW(INDIRECT("1:"&LEN(SUBSTITUTE(A1," ",""))-2)),3)))
**You can change A1 as you need.
**You can change A1 as you need.
Thank you! Works perfectly.