Main Profile

At A Glance

Mr Excel & excelisfun Trick 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.
Length: 08:56

Contact

Questions about Mr Excel & excelisfun Trick 53: Extract State When Text String Has Varying Number of Commas

Want more info about Mr Excel & excelisfun Trick 53: Extract State When Text String Has Varying Number of Commas? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question