Excel Forum

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.