Text lookup

[specialk9203]

Hi There,

I would like to search for a keyword in a text filed and return the subsequent numbers. For example, within a text string there is "MemberID". I would like to capture the following 10 characters after the word MemberID appears.

Any thoughts?

Thanks,
Mike

[Jonmo1]

Try

=MID(A1,SEARCH("MemberID",A1)+8,10)

[specialk9203]

that works perfectly, Thanks!

[Jonmo1]

You're welcome.