thank you for you reply after removing the +0 from Joe formula it worked perfect ( still don't know why the +0 was for)
but you formula didn't work with me because I have many things before the ("D:") I have a long text so I wanted to search for the ("D:" and paste what after it)
your formula pasted all the text except for the ("D:")
sorry I didn't made my request clear..thank you though!
Dates, to Excel, are actually floating point numbers... the whole number part is the number of days offset the day before 1/1/1900 and the decimal part is the fraction of a 24-hour day represented by the time. In Excel, any text number is automatically converted to a real number when it is involved in a mathematical operation. Adding zero to any number does not change the number, so adding zero to a text date converts it to the actual number of days it is offset from the day before 1/1/1900 (which you found out needed to be formatted as a Date in order to see the month, day and year in a familiar format).