How do I Delete Asterisks from contents in a cell of a column (kn.
 

I have an Excel Spreadsheet that I am trying to delete the Asterisks from.
The problem is that the asterisks are woven throughout the contents of a
cell. I do not want to delete those contents, just the asterisk. I usually
use "Find & Replace" to rid my cells of unwanted data, but an asterisk is a
wild card and find & replace does not recognize this character because of
it's wild card status. I deal with thousands of lines of data that I have to
manually edit currently. There must be a better way!!!Stumped in Denver

How do I Delete Asterisks from contents in a cell of a column (kn.
 

You can use the Find and Replace but you have to preceed the wild card with a
Tilde

Search for this ~* and you should be off to the races...

HTH

"StarRider" wrote:

I have an Excel Spreadsheet that I am trying to delete the Asterisks from.
The problem is that the asterisks are woven throughout the contents of a
cell. I do not want to delete those contents, just the asterisk. I usually
use "Find & Replace" to rid my cells of unwanted data, but an asterisk is a
wild card and find & replace does not recognize this character because of
it's wild card status. I deal with thousands of lines of data that I have to
manually edit currently. There must be a better way!!!Stumped in Denver

How do I Delete Asterisks from contents in a cell of a column
 

Another option is this..
Columns("C:C").Select
Selection.Replace What:=Asc(42), Replacement:="", LookAt:=xlPart,
SearchOrder:=xlByRows, MatchCase:=False

"Jim Thomlinson" wrote:

You can use the Find and Replace but you have to preceed the wild card with a
Tilde

Search for this ~* and you should be off to the races...

HTH

"StarRider" wrote:

I have an Excel Spreadsheet that I am trying to delete the Asterisks from.
The problem is that the asterisks are woven throughout the contents of a
cell. I do not want to delete those contents, just the asterisk. I usually
use "Find & Replace" to rid my cells of unwanted data, but an asterisk is a
wild card and find & replace does not recognize this character because of
it's wild card status. I deal with thousands of lines of data that I have to
manually edit currently. There must be a better way!!!Stumped in Denver

How do I Delete Asterisks from contents in a cell of a column
 

Thank You, Thank You, Thank You. this saved me 3 more days work. I can't
thank you enough. Dennis

"Jim Thomlinson" wrote:

You can use the Find and Replace but you have to preceed the wild card with a
Tilde

Search for this ~* and you should be off to the races...

HTH

"StarRider" wrote:

I have an Excel Spreadsheet that I am trying to delete the Asterisks from.
The problem is that the asterisks are woven throughout the contents of a
cell. I do not want to delete those contents, just the asterisk. I usually
use "Find & Replace" to rid my cells of unwanted data, but an asterisk is a
wild card and find & replace does not recognize this character because of
it's wild card status. I deal with thousands of lines of data that I have to
manually edit currently. There must be a better way!!!Stumped in Denver

How do I Delete Asterisks from contents in a cell of a column
 

I think you mean CHR$(42), not ASC(42), right?

On Thu, 17 Feb 2005 10:55:06 -0800, "Patrick"
wrote:

Another option is this..
Columns("C:C").Select
Selection.Replace What:=Asc(42), Replacement:="", LookAt:=xlPart,
SearchOrder:=xlByRows, MatchCase:=False

"Jim Thomlinson" wrote:

You can use the Find and Replace but you have to preceed the wild card with
a
Tilde

Search for this ~* and you should be off to the races...

HTH

"StarRider" wrote:

I have an Excel Spreadsheet that I am trying to delete the Asterisks
from.
The problem is that the asterisks are woven throughout the contents of a
cell. I do not want to delete those contents, just the asterisk. I
usually
use "Find & Replace" to rid my cells of unwanted data, but an asterisk is
a
wild card and find & replace does not recognize this character because of
it's wild card status. I deal with thousands of lines of data that I
have to
manually edit currently. There must be a better way!!!Stumped in Denver