Splitting one cell into 3

[Pypcik27]

How do I split this into 3 separate cells?

Wednesday, June 01, 2011


Thank you!

 

[Jonmo1]

Depends if the cell is an Excel Date, or just a text string.

What does this return?
=ISNUMBER(A1)

 

[Robert Mika]

Text to columns->Delimited->comma,

 

[CWatts]

If it's Text you can use combinations of LEFT MID and RIGHT functions.

If it's a serial date, you can use MONTH DAY YEAR etc.

Provide how you'd like it split and you can get a more specific answer.

 

[Jonmo1]

If that returns TRUE, then try

=TEXT(A1,"dddd") = "Wednesday"
=TEXT(A1,"mmmm dd") ="June 01"
=YEAR(A1) = 2011

If the Isnumber returns FALSE, try Data - Text to columns - Deliminated - Comma



Hope that helps.

 

[Pypcik27]

Thank you!