I have a date cell formatted as "Tuesday, December 11th, 2006" the actual data is "2006/12/11", Im wondering if there is any way to take the text from the formatted column and copy it as text to another column? In other words I want to pull out the day of the week into another column.