Change text to date format.

[srizki]

Is it possible to change text like,

Apr 2017

FEB 2017

Feb 2017

To real dates?

<tbody>
</tbody><colgroup><col></colgroup>

 

[Jonmo1]

Are those in 2 different cells, like A1 is Apr and B1 is 2017 ?

Or both in 1 cell, seperated by a space? Try just =A1+0

 

[srizki]

Thank you Jonmo1,
They both are in one cell.
Apr 2017
Mar 2017 etc.
I tried, but I got #Value! error.

 

[Jonmo1]

If =A1+0 gives a #Value! error, that means there is more in that cell than just the text shown.
Check it for leading/trailing spaces etc.

What does this return
=LEN(A1)

 

[srizki]

9

 

[Jonmo1]

Well it should be 8 right?
APR = 3
Space = 1
2017 = 4


So there's something else in there.
Try
=TRIM(A1)+0

 

[srizki]

That worked, Jonmo1

Thank you.

 

[Jonmo1]

You're welcome.