Text to Column function

[hokeewolf]

I have a column full of dates in this format:

Thursday, January 03, 2013

I want to split this into 2 columns so I can have "Thursday" in it's own separate column.

Text to Column is not doing it for me.....

Any ideas?

THANKS!

Brian

[Kevin UK]

Hi hokeewolf

Text to Columns > Fixed width > Next > Move the break lines as desired > Skip columns you don't want.

text to columns.PNG

[hokeewolf]

That's the problem...the Text To Columns wizard does not show the whole content of the cell!

The preview of selected data only shows "1/3/2013"

[Pepe Le Mokko]

Please post a sample sheet not a picture which is quite useless

[Kevin UK]

If that is a proper date you have in the cells , copy across and format as "dddd"

Or: =CHOOSE(WEEKDAY(A1),"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday")

[Special-K]

If that is a proper date you have in the cells , copy across and format as "dddd"

Or: =CHOOSE(WEEKDAY(A1),"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday")

Shorter is
=TEXT(A1,"dddd")

[hokeewolf]

Yes, Kevin.

"dddd" worked perfect for what I need! I can copy the column to another column to keep the 1/02/2013!

THANKS!!!!

Brian

[ChemistB]

The problem is that what you have in the cell is a number which is formatted as a date, more specifically,
41277 is formatted to display
Thursday, January 03, 2013
If the values are in A (lets say starting in A2)
In B2 = TEXT(A2,"dddd")
In C2 = TEXT(A2, "mmmm dd, yyyy")
Then Copy> Paste Special > Values to remove the formulas
Does that work for you?

[Kevin UK]

Hi hokeewolf

No problem and thanks for the feed back.