The only way I can replicate your problem is if the Text that ou describe is
there as the result of a formula. If it is a formula returning "PO..." then
you can not replace the value... Otherwise the code works for me...
--
HTH...

Jim Thomlinson


"Kristen" wrote:

Thanks for any assistance you can provide. I have looked and can't seem to
find the answer and I don't think it should be that hard.

I have a column that has some text cells that start with "PO....". I would
like to replace all cells in that column with "" or delete the contents. I
thought just replacing with "" would be easiest. I have tried using * and ~
as wildcards. Neither is working

Here is what I was trying to use:

Range("a2:a98").Replace What:="P*", Replacement:=""
--
Thanks - K