Hi,
I hope this has already been answered and wasn't able to find it if it was.
I am trying to extract "AS/DK/LAT1A" from the following "Julho - AS/DK/LAT1Ano1-10". Note that the Text at the front can be any month of the year, so can change in length and the text at the end is also changeable. Also the first letter of the reference "A" can be A or C (CA/UN/CEN2A). I have tried extracting based on the hyphen but am a little stuck with =MID(F2; FIND("-"; F2);11).
Really appreciate the help,
show us an example of your excel file, without confidentional information.
please also add the desired result
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Sorry just solved it myself, was being a bit dim:
=MID(F2; FIND("-"; F2)+2;11)
Hi
Is this text string the same if not another version might come in use!
Formula:
Please Login or Register to view this content.
Regards Kevin
Merged Cells (They are the work of the devil!!!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks