I have a string tu4-0367-6-3-p16-g. I want to find the text between the u and -. The only problem is sometimes it could be 1 character and sometimes it could be two. I don't think i can use mid and find functions because the character count would change.
Is there always a "u" and is there always a hyphen?
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Try this:
Please Login or Register to view this content.
Would you like to say thanks? Please click the: "Add Reputation" button, on the grey bar below the post.
yes there will always be a u and -
@connexionlost, that returned #value!
or, if the "u" might be upper case...
=MID(A1,SEARCH("u",A1,1)+1,SEARCH("-",A1,1)-SEARCH("u",A1,1)-1)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
works for me with the sample you provided.
Of course, the MID function will produce a text string. If you want a numeric value, use:
... from ConneXionLostFormula:
Please Login or Register to view this content.
or
... from FDFormula:Please Login or Register to view this content.
Regards, TMS
Make sure that your text string is in A2 to use the original formula by ConneXionlost.
All the formulae from everyone worked perfectly.
Last edited by newdoverman; 07-31-2013 at 07:31 PM.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks