30 Excel Functions in 30 Days: 15 – REPT « Contextures Blog
REPT is also very useful when it comes to sub string extraction. Consider A1:A3 of: JAKJSAKS-ASHJAH-SJHJ-A123-ASKAJSA ASAJK-ASAS-SHH-D1234569-KJAKJSA AKJKASJ-ASJKA-A-ASKKASJ-A-ASJAHS We wish to retrieve the 4th delimited value in each ......