Page 1 of 1
Get 2 dates
Posted: Sat Oct 30, 2021 8:47 pm
by sna
Hi Dear,
I need your help how to split two dates range to column wise.
I attached a template
Thanks
Re: Get 2 dates
Posted: Sun Oct 31, 2021 3:01 pm
by norkaz
...
B2
=LEFT(A2,SEARCH("-",A2)-1)&RIGHT(A2,5)
C2
=LEFT(A2,SEARCH(" ",SUBSTITUTE(A2,"."," ")))&MID(A2,SEARCH("-",A2)+1,99)
Norkaz
Re: Get 2 dates
Posted: Sun Oct 31, 2021 5:09 pm
by sna
Hi
Thanks for your answer but the date is not real date is just a text,I can't do calculation
Re: Get 2 dates
Posted: Sun Oct 31, 2021 8:24 pm
by norkaz
...
Hi Guy,
The answers were exactly provided by referring to the sample in your attached template #1.
However: refer to #3
B2
=LEFT(A2,3)&"/"&MID(SUBSTITUTE(LEFT(A2,SEARCH("-",A2)-1),"."," "),SEARCH(" ",SUBSTITUTE(A2,"."," "))+1,3)&"/"&RIGHT(A2,4)
C2
=LEFT(A2,3)&"/"&SUBSTITUTE(MID(A2,SEARCH("-",A2)+1,9),",","/")
In case cannot do the calculation or it doesn't work between column B and Column C, please change both formulas to values by copy and paste special "VALUES" in both columns.
Then select B2:B5 -> Data Text to columns -> Next -> Next -> at the Date option, at the drop-down select MDY then Finish.
Then do the same way at C2:C5.
Norkaz
Re: Get 2 dates
Posted: Mon Nov 01, 2021 11:19 am
by sna
Thanks