formula - Excel find text value in string -
i have string such k68272caa6a1 , need that, formula pass first character (i mean string 68272caa6a1 in mind) , formula find first text character. , cell value 7. because first text character "c" , it's 7th character of string (include "k" character).
and after i'll split rest of them. i'm confused issue.
if understand correctly, looking position of 2nd letter in string. number given following array-entered formula.
to enter array formula, hold down ctrl+shift
while hitting enter
. if correctly, in formula bar see braces {...}
around formula:
=match(false,isnumber(mid(a1,row(indirect("2:99")),1)/1),0)+1
the 99
needs number larger length of longest string.
Comments
Post a Comment