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 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.