rcarlyle
Technical User
- Mar 27, 2007
- 21
- 0
- 0
I have a need to replace the * character in a line of text in Excel using a macro. Any clues?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Replace '*' in Excel 2
- Thread starter rcarlyle
- Start date
- Status
-
1
- #2
Hi rcarlyle:
How about ...
Code:
Selection.Replace What:="~*", Replacement:=""Yogi Anand, D.Eng, P.E.
Energy Efficient Building Network LLC
-
1
- #3
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............
----------------------------------------------------------------------------
![[peace]](/data/assets/smilies/peace.gif "[peace] [peace]")
It's easier to beg forgiveness than ask permission![[2thumbsup]](/data/assets/smilies/2thumbsup.gif "[2thumbsup] [2thumbsup]")
----------------------------------------------------------------------------
Regards
Ken............
----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission----------------------------------------------------------------------------
- Status
Similar threads
- Question