Forum Discussion
Crystal_Marceau
Mar 04, 2021Copper Contributor
Extract Text from Cells in Excel
I'm looking for help extracting text from cells. Here's an example DOLPHIN & MERMAID WBA-121500-E SEA TURTLE BEAUT WW-01102001-T I would like to extract the WBA-121500-E and the WW-011020...
Detlef_Lewin
Mar 04, 2021Silver Contributor
PeterBartholomew1
Mar 05, 2021Silver Contributor
Interesting. I have seen Flash Fill demonstrated but never had cause to use it.
A very different route, but I have a copy of Charles Williams's Fast Excel add-in loaded and that supports Regular Expressions.
= Rgx.MID( [@String], "\w{2,3}\-\d{6,8}\-\w" )
I believe Google Sheets also has support for RegEx.
[2 or 3 letters followed by a hyphen, then 6 to 8 digits and a hyphen and, finally, a letter]