Deleting Information from part of a cell

  • Thread starter Thread starter Rory Shortland
  • Start date Start date
R

Rory Shortland

Hi all,

I need to delete part of some information from a column
consisting of 325 cells. The information is set out in
each cell as follows:

Date Time i.e. 29 July 2003 14:25:30

I require to delete the date from each cell and retain the
time, I would like to do all 325 cells at once.

Any advice ? ? ?

Rory
 
If Excel interprets them as true date-time values, then
simply format the column as mm/dd/yy. If they are text
strings, use this formula in another column...

=RIGHT(A1,LEN(A1)-FIND("#",SUBSTITUTE(A1,CHAR(32),"#",LEN
(A1)-LEN(SUBSTITUTE(A1,CHAR(32),"")))))

and fill down. If you wish to convert them into time
values, add a "*1" to the formula and then format as time.

HTH
Jason
Atlanta, GA
 
If your data is text and not all the same length then try Data / Text To Columns / Delimited /
Space as delimiter and choose not to import the first 3 columns

If your data is text and is all the same length then try Data / Text To Columns / Fixed Width and
put a break in between the date and the time.

If your data is in date format, then just change the format.
 
Back
Top