I would use a macro but a formula using this idea would be OK
=SUBSTITUTE(G3,"sprgs","Springs")

--
Don Guillett
SalesAid Software

"Noncentz303" wrote in message
...
I am trying to format data that will be entered into a column. The data is
formated in such a way that COLORADO SPRGS shows up as Colorado Springs .
I
need the full word but Im working with to many records to Find=Replace. I
wrote a If/Then that will take COLORADO SPRGS and make it Colorado Springs
but I have to do it for about 5 to 6 other abbreviations. '

=IF(PROPER('Customer Addresses'!F2)= "Colorado Sprgs","Colorado
Springs",PROPER('Customer Addresses'!F2))

I would like to write a If/Else/then statement if at all possible ....
unless of course im taking the long road on this one.

----I just couldnt find any syntax for what im trying to do