Convert Imported Text????

[Robert Schaub]

Imported text from another file.

Old file people insisted on using all caps.

Is there a way to convert text to title caps, without just going into layout mode and changing the font style.

The fields will be used be an email program and it is pretty ugly to see all caps.

[Fitch]

Proper(text)

[Lee Smith]

Hi Chopper

You are looking for the "Proper function", you can use it in a script or calculation.

HTH

Lee

[Fitch]

Yes, the proper function is the Proper() function.

[Robert Schaub]

Thanks Guys , It was the PROPER thing to due.

Pun Intended.