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 ...
As an alternative, a very short VBA function:
Function GetAnimals(Animals As String, Letter As String)
GetAnimals = Join(Filter(Split(Animals, ","), Letter & "-"), ",")
End FunctionUse like this:
See the attached version (now a macro-enabled workbook).
Yes, I see what you mean! <grin>