Convert Date/Time Format Cell to Date only

The following formula will help you converting date/time format cell to date only in Excel.

Select a blank cell you will place the date value, then enter formula

=YEAR(A2) & "/" & MONTH(A2) & "/" & DAY(A2)

 into the formula bar and press the Enter key.

Convert a list of specific values in a cell from text to numbers

The following formula will help you convert a list of specific text values in a cell to numbers:

Select a blank cell you will place the numbers, then enter the following formula (where “Fusiform” is the first text value)

=IF(BA2="Fusiform"; 1; 2)

Replace the false value of the previous IF formula (eg “2”) with the same IF formula after setting the next text value (eg “Saccular”). Then the formula will look like

=IF(BA2="Fusiform"; 1; IF(BA2="Saccular"; 2; 3))

Continue replacing the false value of this formula (eg. “3”) with another IF formula after setting the next text value (eg. “Pseudoaneurysm”). Then the formula will look like

=IF(BA2="Fusiform"; 1; IF(BA2="Saccular"; 2; IF(BA2="Pseudoaneurysm"; 3; "")))

Carry on the same procedure until you complete the full list of text values. When you add the last IF formula with the last text value leave the false value empty (as “” in the previous example).

References

  1. https://www.extendoffice.com/documents/excel/3526-excel-convert-datetime-to-date.html