Wildcards in If statements

[AJ]

I have cells that contain an alpha character followed by 2 astrisks (i.e.
A**, B**, ...). I also have cells that have an alpha character followed by 2
numbers (A09, C08, ...). I would like to do an if statement to find and
replace the cells with the alpha character and 2 astrisks (i.e. A**, B**,
....) and change them to the alpha character followed by the word total (A
Total). I have tried the following if statements but neither is returning
the correct result. Any suggestions?

=IF(A21="*~*~*","* Total",A21)
=IF(A21="?~*~*","* Total",A21)

 

[Ragdyer]

Try this:

=SUBSTITUTE(A1,"**","Total")

 

[T. Valko]

You can do this in place if you want.

Select the range of data in question
Goto the menu Edit>Replace
Find what: ~**
Replace with: <hit the spacebar> total
Replace All

 

[AJ]

That worked! Thanks.
--
AJ

Try this:

=SUBSTITUTE(A1,"**","Total")

 

[RagDyeR]

You're welcome, and appreciate the feed-back.