Excel Forum
Similar Content
Extract the Last Word from a Cell in Excel - User Defined Delimiter Text Extraction - UDF
Macro: This UDF (user defined function) extracts the last word or characters from a cell in Excel...
Getting Data from a UserForm
Tutorial: How to get data from a UserForm in Excel, including from: text inputs (TextBox), list boxe...
Formula to Delete the First or Last Word from a Cell in Excel
Tutorial: Excel formula to delete the first or last word from a cell. You can copy and paste the fo...
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 57: Extract Many Years from Just Two Years


See Mr Excel and excelisfun take the text string "1997-2000" and create a row of years consisting of 1997, 1998, 1999, 2000. See the functions LEFT, RIGHT, COLUMNS and IF functions. VBA or Formula. Learn about the difference between numbers and text for Logical Formulas.





Got a Question? Ask it Here in the Forum.