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
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