I want to pick out “Month/day” from string like “2023/7/13 0:31:19”.
I tried to it by using a function,LEFT() and RIGHT(),
but it didn’t work.
For example
| Number | A | B |
|---|---|---|
| 1 | 2023/7/13 0:31:19 | RIGHT (A1,5) |
I guessed B1 would be “31:19”,but it was practically
“76852”.
Please tell me how to pick out.
>Solution :
Try this
=MONTH(A1)&"/"&DAY(A1)