Selecting Data in Cell

[JpMpU]

I need to get data from a cell and perform an if statement on it. For example, the data would be "May19 01008Z". I want to take the May19 and put it into date format and perform an if statement on it and also the same for the "Z" at the end of the data.

ANY HELP WOULD BE GREAT!

[bergy]

On 2002-05-17 11:50, JpMpU wrote:
I need to get data from a cell and perform an if statement on it. For example, the data would be "May19 01008Z". I want to take the May19 and put it into date format and perform an if statement on it and also the same for the "Z" at the end of the data.

ANY HELP WOULD BE GREAT!

Is there always a space between the date and the rest of the data? I can't tell from the post. It would make things much easier if there is.

[ This Message was edited by: bergy on 2002-05-17 12:07 ]

[JpMpU]

Yes there ALWAYS is!!!

[bergy]

On 2002-05-17 13:17, JpMpU wrote:
Yes there ALWAYS is!!!

Good! if the data is in cell A2, put this formula in cell B2.

=LEFT(A2,FIND(" ",A2)-1)

that will give you just the date.

Place the following formula in C2.

=RIGHT(A2)

That should give you the very last character.

Hope that works!

[ This Message was edited by: bergy on 2002-05-17 13:45 ]