I am trying to convert the data format from yyyy-mm-dd hh:mm to dd/mm/mmmm 
I've been trying different solutions but none of them works, the closest one was this:

```
Columns("I:I").Replace What:=" *", Replacement:="", LookAt:=xlPart
Columns("I:I").TextToColumns Destination:=Range("11"), _
DataType:=xlDelimited, FieldInfo:=Array(1, xlDMYFormat)
Columns("I:I").NumberFormat = "dd/mm/yyyy"

```

But it throws me an error in this two lines:

```
   Columns("I:I").Replace What:=" *", Replacement:="", LookAt:=xlPart
  Columns("I:I").TextToColumns Destination:=Range("11"), _

```