30 Excel Functions in 30 Days: 27 – SUBSTITUTE « Contextures Blog
As outlined on a prior post SUBSTITUTE combined with REPT can be handy to retrieve a specific sub section of a string A1: "The Cow Jumped Over the Moon" B1: 3 C1: =TRIM(MID(SUBSTITUTE(A1," ",REPT(" ",LEN(A1))),1+LEN(A1)*(B1-1),LEN(A1))) the above ......