Hi Otto,
I can select European rows and apply the change to them only. There are 2
possible descriptions in European rows:
1. Quest has it requisition #7847. Sample collected on 6/17/08
2. Not listed on Quest report. Sample collected on 4/23/08
I only need to change Europeans to look like Americans or all Americans to
look like European dates. I can't have any mix. The preference will be teh
European date format. I would like to change the above dates to look like
this: 17/06/08 and 23/04/08 with zero added to a day and a month.
Thank you.

"Otto Moehrbach" wrote:

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?