Working with dates in excel

[Yugaa2010]

Hi,

cell A1 = 12, January, 2020, 15, February, 2020, 16, march, 2020............

The above shown text available in in single cell
i am expecting results like in different cells a2 a3 a4 ....
12/January/2020
15/February/2020
16/March/2020

Could you please suggest any idea how can i do this ?
Thanks in advance

 

[GraH]

Hi, you can try B1=Substitute (A1,",","/")
Or use CTRL+H to replace , with /.

 

[footoo]

Format column A as dd/mmmm/yyyy then :

Sub v()
Dim s, r%, i
s = Split(Trim([A1]), ", ")
r = 2
For i = 0 To UBound(s)
    Cells(r, "A") = s(i) & "/" & s(i + 1) & "/" & s(i + 2)
    r = r + 1
    i = i + 2
Next
End Sub

The data in A1 needs to be exactly in the format as posted with the separator ", "

 

[Yugaa2010]

Format column A as dd/mmmm/yyyy then :

Sub v()
Dim s, r%, i
s = Split(Trim([A1]), ", ")
r = 2
For i = 0 To UBound(s)
    Cells(r, "A") = s(i) & "/" & s(i + 1) & "/" & s(i + 2)
    r = r + 1
    i = i + 2
Next
End Sub

The data in A1 needs to be exactly in the format as posted with the separator ", "

Hi Thank you
its working very good.

If possible can you please modify for this text as well.

A1 =

june 8, 2020, july 8, 2020, august 9, 2020...

Thanks in advance

 

[Yugaa2010]

Hi, you can try B1=Substitute (A1,",","/")
Or use CTRL+H to replace , with /.

Thank you i will try this

 

[GraH]

Oh, seems I overlooked the dates are all in a single cell. Sorry for this, Yugaa2010, can't blame it on sleepy eyes (it was after noon).
The VBA code provided is better then any Power Query M-code I can come-up with.

 

[footoo]

If possible can you please modify for this text as well.
A1 =

june 8, 2020, july 8, 2020, august 9, 2020...

Sub v()
Dim s, r%, i
s = Split(Trim([A1]), ", ")
r = 2
For i = 0 To UBound(s)
    Cells(r, "A") = s(i) & ", " & s(i + 1)
    r = r + 1
    i = i + 1
Next
End Sub

Format column A as required.