Forum Discussion
Excel Text Manipulation II
Device: PC/Windows 10 Microsoft Office Home and Business 2013 Excel Product ID: 00196-20943-85146-AA714 Dear Community, Here is my second posting on this subject. By myself I am making a bit ...
Joel_Bauer Here is another solution not as elegant as the previous but may help give you some ideas on techniques you can use. Here is the formula:
=LET( source,[@Animals],
filter_key, "a",
length,LEN(source),
list_expanded, SUBSTITUTE(source,",",REPT(" ",length)),
array, TRIM(MID(list_expanded,SEQUENCE(length-LEN(SUBSTITUTE(source,",",""))+1,,1,length),length)),
filtered, FILTER(array,LEFT(array,2)= filter_key&"-"," "),
TEXTJOIN(", ",TRUE,filtered))oh wait. I just notice you don't have excel 365 so forget that response as you won't have the LET() function. This could actually be converted to your version but the size of the equation would be large to say the least.