Replace * on the worksheet
Use Find and Replace...
Enter ~* in the find box click on Replace All
You can enter a BLANK in the Replace box if you want to replace 'THI*S' with
'TH S'
"leo" wrote:
I have lot of * along with other data. How can i replace * with blanks
|