strip characters out of a field

  • Thread starter Thread starter IT
  • Start date Start date
I

IT

Is it possible to write a formula to do the following:

Take

02-Jan-03 07:47:48

and strip out the time to make the field look like

02-Jan-03

Thanks, Matt
 
IT,

We need to know if this is a text field or a date field.

If it's a text field, it's simply = left(A2,9)

If it's a date field, then = int(a2)
or just format, cells, select "dd-mmm-yy"

will probably work.

regards,

JohnI
 
Back
Top