Then use the macro. This is what I would do.

--
Don Guillett
SalesAid Software

"Noncentz303" wrote in message
...
I like all of these ideas.... Man I never knew excel had so many options
for
the same goal. I guess im thinking old school lol. Don I like your idea
for
the substitute function but the pivot table will give some others a chance
to
add and remove entries for the pivot table.

Thanks guys for the solution to my problem


"Don Guillett" wrote:

For multiples you can nest it
=SUBSTITUTE(SUBSTITUTE(G5,"ddddd","Don"),"sprgs"," Springs")

Sub replacetexts()
With Range("f2:f22")
.Replace "ddddd", "Don"
.Replace "sprgs", "Springs"
.etc
End With
End Sub
--
Don Guillett
SalesAid Software

"Don Guillett" wrote in message
...
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