Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
StarRider
 
Posts: n/a
Default Removing Asterisks from the contents of a cell

Any ideas on how I can remove asterisks from the contents of a cell. Knowing
the Asterisk is a wild card and does not behave like other characters when
using "Find & Replace"


  #2   Report Post  
Tom Hayakawa
 
Posts: n/a
Default

Use a tilde (the key to the left of the 1 on most keyboards) in front of the
asterisk, like so: ~*
That tips off Excel that you really want to deal with the asterisk as a
character and not a wild card.

Good luck.

"StarRider" wrote:

Any ideas on how I can remove asterisks from the contents of a cell. Knowing
the Asterisk is a wild card and does not behave like other characters when
using "Find & Replace"


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding contents of one cell to a range of cells. CLJinVA Excel Worksheet Functions 1 February 10th 05 10:19 PM
make cell contents equal to null value - not blank, but empty mpierre Excel Worksheet Functions 1 December 29th 04 06:57 AM
Cell contents vs. Formula contents Sarah Excel Discussion (Misc queries) 3 December 15th 04 06:02 PM
Display actual contents of cell xmasbob Excel Discussion (Misc queries) 1 December 6th 04 05:09 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM


All times are GMT +1. The time now is 10:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"