Excel Forum
Similar Content
NPER Function - Calculate Number of Periods Needed for a Set of Payments in Excel
Tutorial: How to calculate the number of periods required for an investment in order to get the desi...
Filter Data to Show the Top X Number of Items in Excel - AutoFilter
Macro: This Excel macro filters a data set to display only the top X number of items in that data...
Count the Number of Cells that Contain Specific Text in Excel
Tutorial: How to count the number of cells that contain specific text within a spreadsheet in Excel....
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



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.





Got a Question? Ask it Here in the Forum.