We have some customers sending in sheets for processing and the guys in the office are spending ages trying to re format. (please see attached)
1 - Particularly dates that have a dot or dash at the end. What's the best way to get these re-formatted ...some sort of Case structure ?? Replace Right , 1, with "" if it's a dot or dash ?
2 - The other pain is those Users putting a ", as in DITTO, for dates. Is there a way to replace the " with the offset of (-1,0) ..sort of thing ?? ...being mindfull that there may be several in succession.
Any help with above appreciated.
Edited by: Squire_King on 05.25.04.