macro for Multiple Filters

Question

Hi

I have Following Data from A to Z

At present I'm using multiple Filters to split records based on names starting with Alphabets , I would like create separate files in excel based on names

dataManiManiAshokAshokAshokAshokBaluBaluBaluCementCementDhruvaDhruvaDhruva

At present I'm using this formula and multiple filters

Qiu · Accepted Answer

@BRRLL99 
I think this is a good application senerio for "Take file/table name from field" option for the Output tool.

Simple in below.