Get proper case to make exceptions in transforming address fields in a large excel file

[TAMITY]

Hi,

I have a file with a few thousand address fields which I want to covert to proper case , using =Proper(A2).

However, I don't want to manually fix things like :

Proper case converted text	Should be
Of	of
In	in
At	at
As	as
Uk	UK
Plc	PLC
And	and
The	the
3Rd	3rd
St	ST.

<colgroup><col width="227" style="width: 171pt; mso-width-source: userset; mso-width-alt: 6715;"> <col width="184" style="width: 138pt; mso-width-source: userset; mso-width-alt: 5435;"> <tbody> </tbody>

Is there a way to exclude these conversions while proper casing or is there a quicker way to fix them , without using the global find and replace?

Thank you.

 

[oldbrewer]

Re: How to get proper case to mak eexceptions in transforming address fileds in a large excel file

find space Of space replace with of - - - ten like this less than one minutes work ?