Excel function to convert date "2011-11-04-23.22.10.446908" to "2011-11-04"

=MID(A2,SEARCH("2011",A2,1),10)

Excel Function to change date in "2011-02-10 19:18:11" format to "10/02/2011 19:18:11" format

=CONCATENATE(MID(N2,SEARCH("-",N2)+4,2),"/",MID(N2,SEARCH("-",N2)+1,2),"/",MID(N2,SEARCH("-",N2)-4,4)," ",MID(N2,SEARCH(":",N2)-2,2),":",MID(N2,SEARCH(":",N2)+1,2),":",
,MID(N2,SEARCH(":",N2)+4,2))