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 :

[TABLE="width: 309"]
<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>[TR]
[TD="class: xl64, width: 227, bgcolor: #B7DEE8"]Proper case converted text[/TD]
[TD="class: xl65, width: 184, bgcolor: #B7DEE8"]Should be [/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]Of[/TD]
[TD="class: xl67, bgcolor: transparent"]of[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]In[/TD]
[TD="class: xl67, bgcolor: transparent"]in[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]At[/TD]
[TD="class: xl67, bgcolor: transparent"]at[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]As[/TD]
[TD="class: xl67, bgcolor: transparent"]as[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]Uk[/TD]
[TD="class: xl67, bgcolor: transparent"]UK[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]Plc[/TD]
[TD="class: xl67, bgcolor: transparent"]PLC[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]And[/TD]
[TD="class: xl67, bgcolor: transparent"]and[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]The[/TD]
[TD="class: xl67, bgcolor: transparent"]the[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]3Rd[/TD]
[TD="class: xl67, bgcolor: transparent"]3rd[/TD]
[/TR]
[TR]
[TD="class: xl66, bgcolor: transparent"]St[/TD]
[TD="class: xl67, bgcolor: transparent"]ST.[/TD]
[/TR]
</tbody>[/TABLE]


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 ?