Excel Workbook | ||||
---|---|---|---|---|
A | B | |||
1 | D: 05/08/2018 | 05/08/2018 | ||
Sheet2 |
Cell B1 is formatted as "mm/dd/yyyy"
Sheet2
A B 1 D: 05/08/2018 05/08/2018
<colgroup><col style="width: 30px; font-weight: bold;"><col style="width: 92px;"><col style="width: 75px;"></colgroup><tbody>
</tbody>
Spreadsheet Formulas
Cell Formula B1 =RIGHT(A1,LEN(A1)-FIND("D: ",A1)-2)+0
<tbody>
</tbody>
<tbody>
</tbody>
Excel tables to the web >> Excel Jeanie HTML 4
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).thank you for you reply after removing the +0 from Joe formula it worked perfect ( still don't know why the +0 was for)
I did not realize you had more text in front of the "D:". Given that, this version of my formula should work for you then...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:")