Separate Date

[Reec0n]

An easy one for the forum I'm sure:

I have a list of these:

Wed Aug 01 11:13:36 2018 I would like to take the date only and have them in a separate column like this 01/08/2018 All help welcomed, tia

<tbody>
</tbody>

 

[Scott Huish]

Assuming it's only the date and time in your cell:

=(MID(A1,5,6)&", "&RIGHT(A1,4))+0

Format as the date format dd/mm/yyyy

Excel 2010
	A	B
1	Wed Aug 01 11:13:36 2018	01/08/2018
Sheet1

Cell Formulas
Range	Formula
B1	=(MID(A1,5,6)&", "&RIGHT(A1,4))+0

 

[Reec0n]

Assuming it's only the date and time in your cell:

=(MID(A1,5,6)&", "&RIGHT(A1,4))+0

Format as the date format dd/mm/yyyy

Excel 2010

	A	B
1	Wed Aug 01 11:13:36 2018	01/08/2018

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula B1 =(MID(A1,5,6)&", "&RIGHT(A1,4))+0 <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

Thank you for this; however, I get a #VALUE ! error? it is the same as above so not sure -if i remove the +0 at the end i get date as Aug 01, 2018 :|

 

[Scott Huish]

I wonder if you have extra spaces in that.

Does this work for you?

=(TRIM(MID(A1,5,6)&", "&RIGHT(A1,4)))+0

 

[Reec0n]

I wonder if you have extra spaces in that.

Does this work for you?

=(TRIM(MID(A1,5,6)&", "&RIGHT(A1,4)))+0

Hi,

No extra spaces and still not joy

 

[Scott Huish]

Can you post an exact example of the data where it is not working?