Copying part of a text cell in Excel

I have a spreadsheet with cell which contain dates.  The format is this "Thu 23 January 2014".  I want to copy only the date i.e. "23 January 2014" to another cell.  Please keep in mind this covers the entire year from 1 January 2014 to 31 December 2014.
mabarnes11Asked:
Who is Participating?
 
GeisrudSystems AdministratorCommented:
Assuming your text is in cell A1
=RIGHT(A1,(LEN(A1)-4))
0
 
duttcomCommented:
The Thu is only appearing because of the cell's formatting. If you copy the value of one cell to another, you only need to set the format of the copied cell to the date only format and the Thu will not appear.
0
 
mabarnes11Author Commented:
Not true.  The cell containing the current day, date is a text cell containing these text letters and numbers "Thu 23 January 2014" and will not format.
0
 
Angelp1ayCommented:
It seems Excel doesn't recognise that format for a date.

You can:
- Add a column with the formula: =RIGHT(A2,LEN(A2)-4)
- Add another column and copy > paste values into it from the formula column
- Select your new column, select from the ribbon tab Data > Text to Columns
- Select delimited to make sure your date isn't split, and select the date column type
- Delete the first 2 columns

...now you actually have dates Excel recognises! :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.