Mar 17 2022 07:05 PM
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 data I'm starting with, and the column on the right is what I need to end up with. This example was done manually.
Ainsworth | ain/ins/nsw/swo/wor/ort/rth |
Bandon | ban/and/ndo/don |
Devils Lake | dev/evi/vil/ils/lsl/sla/lak/ake |
Mar 17 2022 08:37 PM - edited Mar 17 2022 08:38 PM
SolutionMar 17 2022 08:54 PM