Replace '*' in Excel 2

[rcarlyle]

I have a need to replace the * character in a line of text in Excel using a macro. Any clues?

 

[yogia]

I have a need to replace the * character in a line of text in Excel using a macro. Any clues?

Hi rcarlyle:

How about ...

Selection.Replace What:="~*", Replacement:=""

Yogi Anand, D.Eng, P.E.
Energy Efficient Building Network LLC

http://www.energyefficientbuild.com

 

[KenWright]

You have to precede any wildcard character with a tilde in order to do a 'find and replace', whether it be manually or via vba.

Regards
Ken............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------