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.

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.

Ask Your Question

Weekly Poll