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

Popular posts from this blog

android - Gradle sync Error:Configuration with name 'default' not found -

java - Andrioid studio start fail: Fatal error initializing 'null' -

html - jQuery UI Sortable - Remove placeholder after item is dropped -