Roy,

They are located in the VBA library, typically located in
C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6.DLL
.. If this library is marked MISSING in the References dialog,
you should unregister then reregister Excel with Windows.

Close Excel, then go to the Windows Start menu, choose Run, and
enter
Excel.exe /unregserver
Then, run Excel again with
Excel.exe /regserver

Finally, start Excel normally.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Roy" wrote in message
...
Excel XP cannot find MID, RIGHT or LEFT functions....
What reference library are they located in?

Thanks!