Vic
Can you provide any logic with which to find the date in the cell entry?
Something perhaps like:
The date always starts with the 7th character in the cell.
Or
The first character in the date is always the first numerical character in
the cell.
Or
The date is always 8 characters long and is the only part of the entry that
has slashes.
Or
???
HTH Otto
"Vic" wrote in message
...
I need to change DD/MM/YY to MM/DD/YY in a description field but not in all
cells. The date is in the middle of description. All American description
fields have dates in MM/DD/YY and all European description fields have
DD/MM/YY. Please keep in mind that this is NOT a date field and the field
contains other words besides the date. The date is in the middle of the
description.
How do I do that?