Partial replace

[Sept]

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

 

[Max]

One way ..

Assuming data in A1 down,

Put in B1:
=TRIM(SUBSTITUTE(A1,"**"," "))
Copy down

 

[Bob Phillips]

Sandra,

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