Excel Forum
Similar Content
Get the Number(s) Out of a Cell that Contains Both Text and Numbers in Excel - UDF
Macro: This free Excel UDF allows you to get the numbers out of a cell that contain both text...
Excel Formula to Get Domain Name from a URL
Tutorial: Two formulas that you can use to extract the domain name from a URL or to extract the sub-...
Top Excel Keyboard Shortcuts to Increase Productivity
Tutorial: I'll show you the top keyboard shortcuts for Excel that are sure to increase your producti...
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




Excel Magic Trick #224: Extract Prefix From Product ID


See how to extract prefix from product id when there is no dash or space to establish a pattern. See the LEFT, MATCH, ISERROR, ROW, INDIRECT and LEN functions in an array formula.
Extract part of a text string from a longer text string.





Got a Question? Ask it Here in the Forum.