View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Asterix, how to replace it?

Hi,

In the search box put a tilde ~ in fron of the asterix

Mike

"Kupa72" wrote:

HI,

Help needed for following problem;

I'll have a lot of rows/colums(like 50 000) where is text and numbers.
Some of those lines have Asterix (*) character, it is allways first character.
How can I replace/remove that sign without doing it manually.
If I use replace function, it delete all characters in that column.

Thank you in advance,

Kupa72