Partial replace
 

Hello,
I'm trying to search and replace but I do not want to replace the whole
cell, only a few characters in them.
Namely, I have list of names, some of which have two stars ** after it and I
want to get rid of those 2 stars after the name. How do I do that?
Thanks a lot
Sandra

One way ..

Assuming data in A1 down,

Put in B1:
=TRIM(SUBSTITUTE(A1,"**"," "))
Copy down
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Sept" wrote in message
...
Hello,
I'm trying to search and replace but I do not want to replace the whole
cell, only a few characters in them.
Namely, I have list of names, some of which have two stars ** after it and
I
want to get rid of those 2 stars after the name. How do I do that?
Thanks a lot
Sandra

Sandra,

Just do a find and replace, Ctrl-H, but precede the * with a tilde ~, so ~**
as the string to replace.

--
HTH

Bob Phillips

"Sept" wrote in message
...
Hello,
I'm trying to search and replace but I do not want to replace the whole
cell, only a few characters in them.
Namely, I have list of names, some of which have two stars ** after it and
I
want to get rid of those 2 stars after the name. How do I do that?
Thanks a lot
Sandra