Extract text

How about

Formula:

Please Login or Register  to view this content.

I could do it in one (long) formula, but it would be more efficient to use a helper column for the intermediate result - is this acceptable?

Pete

Here's another one for B3:

=TEXT(MID(A3,IFERROR(SEARCH("-c-",A3),SEARCH("-L-",A3))+3,SEARCH("_",A3)-IFERROR(SEARCH("-c-",A3),SEARCH("-L-",A3))-3),"[>999]00\/00;0")

Copy down as required.

Hope this helps.

Pete

It is a Custom Format, where you can specify a simple condition - in this case it is greater than 999 (meaning a 4-digit number). So, if it is a 4-digit number then use the format string 00/00, otherwise use 0.

Hope this helps.

Pete

By the way, if that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

You might also like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete

All formula are working great

Glad to help & thanks for the feedback.

Pete,

Thanks for your explanation. May I know purpose for backward slash "\" ?
I saw the difference if i removed "\" but still don't get the meaning of it.

Thanks.

It is basically an "escape" character, meaning to take the following character literally, in this case the forward-slash.

Hope this helps.

Pete

Pete, got it.

Thanks a lot for your explanation and thanks for all those help me. Have a good day ahead.

You're welcome - thanks for the rep.

Pete

Cell B3 formula , drag down

HTML Code: 

wk9128, working well. thanks for your alternative idea.

You're Welcome. Thank You for the feedback