Question : excel find position of second to last character in a string
Answered by : brian-w
=FIND(CHAR(160),SUBSTITUTE(text,"@",CHAR(160),N))
Source : https://exceljet.net/formula/find-nth-occurrence-of-character | Last Update : Thu, 10 Sep 20
Answered by : brian-w
=FIND(CHAR(160),SUBSTITUTE(text,"@",CHAR(160),N))
Source : https://exceljet.net/formula/find-nth-occurrence-of-character | Last Update : Thu, 10 Sep 20