About Us

Don Guillett

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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
IF statement with multiple values...	guy.pembroke	Excel Worksheet Functions	12	May 13th 09 03:42 AM
Returning a string of values in an IF statement	Dave F	Excel Discussion (Misc queries)	1	January 11th 07 01:33 AM
using If statement to change values in a range	arrow	Excel Worksheet Functions	5	January 30th 06 12:22 AM
Compare 2 cells values with one IF statement	jbsand1001	Excel Worksheet Functions	1	June 9th 05 06:15 PM
if statement between values	Qaspec	Excel Worksheet Functions	2	February 21st 05 02:06 AM

Menu

About Us