Function for String between 2 characters?

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

zbor,
Thanks for the alert.
My requirement is to get the string value between two characters(eg : "-").
Suppose if xxx-yyyyy-zzz is the string in any cell(say A1).I want the result as yyyyy.

Please Login or Register  to view this content.

I have the above function.But when I use it as =midtxt(A1) it returns 0.
Please tell me where I have gone wrong.

If I use the same logic for a command button then the code works fine.

Thanks and Regards.

In function you need to retrun result as name of the function:

Please Login or Register  to view this content.

But, since your function might fail when having more - in string I suggest you to use this:

Please Login or Register  to view this content.

You can also set separator if you like:

Please Login or Register  to view this content.

Use it as:

Formula:

Please Login or Register  to view this content.

And you can also set n-th word to be returned as:

Please Login or Register  to view this content.

Where you can use formula as:

Formula:

Please Login or Register  to view this content.

This will return 3rd word (ccc).

Now you have full flexibility of what is separator and what part to return

Thank you very much zbor and karedog!
A big thanks for all the answers.