Seperate Number & date with formula

[RAJESH1960]

Hello experts
I would like to know how is it possible to seperate the number and date from column A and get the values in the next column B and C,with the help of a formula. The column A has a date value in all cases but has number in some cases only. The number and date are seperated by " / " in all cases. I can use the text to columns option but as the sheet is hidden, I want the formula to auto calculate in diffferent columns.

Book2
	A	B	C
1	No. & Date	Number	Date
2	44540 / 1-10-2021
3	4454 / 1-1-2021
4	528 / 10-10-2021
5	52863 / 10-1-2021
6	/ 22-10-2021
7
Sheet1

 

[DanteAmor]

Got it right with a little editing.

only select the format in the cell

varios 28ene2022.xlsm
	A	B	C
1	No. & Date	Number	Date
2	44540 / 1-10-2021	44540	01-10-2021
3	4454 / 1-1-2021	4454	01-01-2021
4	528 / 10-10-2021	528	10-10-2021
5	52863 / 10-1-2021	52863	10-01-2021
6	/ 22-10-2021		22-10-2021
Hoja19

Cell Formulas
Range	Formula
B2:B6	B2	=LEFT(A2,FIND(" /",A2))
C2:C6	C2	=REPLACE(A2,1,FIND("/",A2)+1,"")+0

 

[RAJESH1960]

Done, I formatted the whole column > date > Custom > dd-mm-yyyy, and then entered the formula. Thank you guys.

 

[DanteAmor]

Glad we could help & thanks for the feedback