PDA

View Full Version : match data and return datalength



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

Aussiebear
11-26-2011, 03:08 PM
Are you requesting a, "match" as in exact copy or if the B1 string value is "found" within the A1 string value?

mancubus
11-26-2011, 03:15 PM
hi hunna.

formula in C1:

=IF(ISERROR(FIND(B1,A1,1)),"NO MATCH",LEN(B1))

hunna
11-27-2011, 10:36 PM
Thank you all for you kind help!!! it is working great.