How to delete a space from the middle of a date
I've imported several date fields and many were originally entered with an extra space within the date. For instance: 7/ 3/ 08
A calculation based on that field will not work unless it is retyped or re-entered as 7/3/08 with those extra spaces deleted.
How can I remove them? Isn't TrimAll just for leading and trailing spaces?
Thanks for any suggestions!
Jane in LR