how to extract only date from a cell with other ref also.

December 26, 2011 at 22:50:57
Specs: Windows XP, 2 GB
how to extract only date from a cell containing text or numerical value and date like 785454/01.12.10 or 785454-01/12/10.

See More: how to extract only date from a cell with other ref also.

Report •

#1
December 27, 2011 at 09:31:14
Based on your examples, it appears that the date is the 8 right-most characters, therefore this should work:

=RIGHT(A1, 8)

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question