How do I delete recurring unwanted text within cells????

[sheetspread]

example:

****DAFSDKAHK
****ASFDLFJAL
ASDFASDFF
GHGHHGHG
YTRREDSFA
HHFGFRTRE
****SFDFFASDASFD

I just want to remove the asterisks, but find and replace deletes the whole sheet.

 

[jimbojones]

Hi,

Use find and Replace but with a tilde first:

~*

and replace with blank.

Any use?

James

 

[sheetspread]

ah, prompt and perfect reply

thanks