Strange behavior in Excel

[JeanW]

I got an Excel file with text (customer names), made on a Mac, don't know which version.

Open it in Excel (Office 2000 Pro on Win 2000 Pro).

A weird thing seems to have happened.
Every instance where the letter R preceded the letter T, the R is deleted and the letter C is inserted after the T.

Ex. Courtyard came through as Coutcyard
Cortland as Cotcland
Fortino as Fotcino

Anyone a clue what's going on ?
I contacted my collegue and at his side nothing is wrong.

 

[JPaules]

Did you look for any autochanges?

--
JP

 

[JeanW]

oops......silence....

Euh...no...

But I did now, and can't find anything....

(will put that in my 'to look for...' file, thanks)

 

[JohnOB]

You could try doing a find replace to resolve, by choosing highlighting the entire sheet and then choosing Edit > Replace and in the Find What field type tc and in the Replace with field type rt, then hit Replace All.

"Stupid isn't not knowing the answer, it's not asking the question

 

[JPaules]

Is it just one file that's affected or all? What file format did you get this data from?

--
JP

 

[JeanW]

OK, after a few more questions to the other side:

The data is an Excel file made on a Mac (don't know which OS)in MS Office for Mac 08 ( ? ) with data coming out of an Access file.

I have no idea how they make the Excel file, just export or save the data as Excel, I don't know.
And they can't tell me ( go figure).

It seems to happen during the process of going from Access to Excel.

It's not such a problem, with Find/Replace I can find most of the errors. I do not think we can do something about it.
I just have to watch out for it....

Thanks for all the replies, appreciate.