Dueling Excel 53

Extract State When Text String Has Varying Number of Commas


See Mr Excel and excelisfun show how to do a VBA and an array formula method to extract State data from a column of address data. INDEX and MATCH functions and Non Ctrl + Shift + Enter Formula Trick using INDEX array argument and a blank in the row argument for INDEX


Be the first to comment

Leave a Reply