Identify the keyword length in the string

[sathishkm]

Hi All,

I have a string in the excel where I need to identify the particular keyword in that string and find the length of the string position where it occurs. Please find the attached excel.

Thanks

[FDibbins]

Try this...
=IF(ISERROR(SEARCH(" at ",A2)),0,LEN(A2))

[sathishkm]

Result are coming wrong. Please check the attachment.

[Pete_UK]

Try this formula instead in B2:

=IFERROR(SEARCH(" at ",A2)-1,LEN(A2))

then copy down as required.

Hope this helps.

Pete

[sathishkm]

Results are coming wrong.

[jindon]

try

=IFERROR(SEARCH(" at ",A2)-1,LEN(A2))

[sathishkm]

Result are coming wrong. Please check the attached excel

[jindon]

You are confusing us...

=IFERROR(SEARCH(" at ",A2)-1,0)

[AliGW]

Try this:

=IFERROR(FIND(" at ",A2)-1,0)

Are you still using Excel 2007???

[TMS]

Try:

Please Login or Register  to view this content.

[FDibbins]

1. You have changed the 1st file you posted. I dont recall the rest of the values, but the 1st number you gave was definitely 48, not 40!! Please do not change the data you provide - if you need to change it, add a 2nd file.

2. explain how you arrive at (the new value of) 40 when "at" starts at position 42 please