hunna
11-26-2011, 12:29 PM
Hi there,
I have data
in A1 = ADGSTSJDUDKDKFHDHFGFGDHAPPPPSODIDFKLFK
in B1 = GDHAPPP
I need to show a number of characters (=LEN(B1)) in C1 if data in B1 matches to A1
so in this case I expect C1 will show 7
any help would be appreciated,
thanks
I have data
in A1 = ADGSTSJDUDKDKFHDHFGFGDHAPPPPSODIDFKLFK
in B1 = GDHAPPP
I need to show a number of characters (=LEN(B1)) in C1 if data in B1 matches to A1
so in this case I expect C1 will show 7
any help would be appreciated,
thanks