How to remove *

[sdsurzh]

Hi,


I have list of years and i want to remove * special character alone from the list.


Source:

2009

2010*

2011*

2012


Output:

2009

2010

2011

2012


Thanks,

Suresh Kumar S

 

[shrivallabha]

Hi Sureshkumar,


Find: ~*

Replace: Keep empty


Replace all


When you need to replace * which is wildcard character you need to use tilde (~) along with it.

 

[sdsurzh]

Thanks shrivallabha,


where i can find the ~ on keyboard.

 

[joharmenezes]

~ is found below the esc key

 

[sdsurzh]

Thanks T100,


I thought some other char-key will be there for ~ .

 

[SirJB7]

Hi, Suresh Kumar!

Alt-126.

Regards!

 

[sdsurzh]

Thanks SirJB7.

 

[shrivallabha]

Hi Suresh,


The button that carries tilde(~) is useful for chandoo forum use as it carries backtick character used for posting VBA code.


It has one more excel specific use. In an excel sheet if you press CTRL + ~ then it will show you formulas.

 

[bobhc]

Good day All


Depending on your local and keyboard layout the tilde could be on the hash (#) key just above the right hand shift key

 

[SirJB7]

Hi, Suresh Kumar!

Glad you solved it. And welcome back whenever needed or wanted.

Regards!

 

[sdsurzh]

Thanks to all