Converting TEXT to DATE

  • Thread starter Thread starter GFH
  • Start date Start date
G

GFH

Evening

I have two simalar issues.

1) I have a column of text that represents the date but is entered as
text. The entry has a leading space (entered as "<sp>12 DEC 06") that
does not permit the entry to be displayed or treated as a DATE cell.

Question how can I strip the leading space from a cellso I can format
and display the cell as a DATE?


and 2nd

Another column has a time entry with the same leading zero as well as
one after the full colon "<sp>9:<sp>34" without quotes of course.

Same question is there an easy way to get rid of the leading space s
well as the <sp> after the colon?

Thank you

G
 
Use the DATEVALUE() function

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Evening
|
| I have two simalar issues.
|
| 1) I have a column of text that represents the date but is entered as
| text. The entry has a leading space (entered as "<sp>12 DEC 06") that
| does not permit the entry to be displayed or treated as a DATE cell.
|
| Question how can I strip the leading space from a cellso I can format
| and display the cell as a DATE?
|
|
| and 2nd
|
| Another column has a time entry with the same leading zero as well as
| one after the full colon "<sp>9:<sp>34" without quotes of course.
|
| Same question is there an easy way to get rid of the leading space s
| well as the <sp> after the colon?
|
| Thank you
|
| G
 
=TIMEVALUE(A1)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|
|
| BEautifull!
|
| Thank you Niek
|
| Any ideas on the second question?
|
| G
|
| On Thu, 4 Jan 2007 08:31:10 +0100, "Niek Otten" <[email protected]>
| wrote:
|
| >Use the DATEVALUE() function
 
Back
Top