How do I extract from string?

[tomengers]

I can use Count to tell me whether or not a desired value lives in a string, but how can I get the starting location of that value so I can extract it?

... tks in advance

... tom

[pnchowdary]

Hi Tom,

You can use the Index function.

Code: Select all

Index (string, substring, instance)