Extract some characters in a mixed string

[C_Udma]

Hi
I have a formula to extract what comes after the '/' in a string of text and parse it as a number, please see the 3rd column in the attached Excel sample file. Can someone help me to separately extract what comes before the '/'? It is usually a string in the form of PR0000.0000 (PR then number of four characters, then dot, then number of four characters, but sometimes there are typing errors and the string is different, so I'd need a formula that doesn't care about how many characters are before the '/'. Would be great if I can get the new formula in the E column. Thank you so much, Cris.

[AliGW]

Like this:

=LEFT(B2,FIND("/",B2)-1)

[C_Udma]

Love you , AliGW, exactly what I need, thank you so much!
Cris

[AliGW]

LOL!!!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.