Extract Month and Day from string

[allwrighty]

Good afternoon,

I need to extract the month and day from a date / time string into another cell. An example of the string is 1/28/2014 10:26

I want the result to be 1/28

Thanks for your help

[azumi]

Maybe
=TEXT(A1,"MM/DD")

[bebo021999]

With string in A1:
=LEFT(A1,SEARCH("/",A1,SEARCH("/",A1)+1)-1)

[allwrighty]

Thanks Azumi. I knew this had to be something simple but I was drawing a complete blank.

Allwrighty

[azumi]

Yes you're welcome