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)



--
AJ

Try this:

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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"AJ" wrote in message
...
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)



--
AJ

You can do this in place if you want.

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

--
Biff
Microsoft Excel MVP


"AJ" wrote in message
...
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)



--
AJ

That worked! Thanks.
--
AJ


"Ragdyer" wrote:

Try this:

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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"AJ" wrote in message
...
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)



--
AJ

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

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"AJ" wrote in message
...
That worked! Thanks.
--
AJ


"Ragdyer" wrote:

Try this:

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

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"AJ" wrote in message
...
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)



--
AJ