Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can you delete all asterisks in a sheet? | Excel Discussion (Misc queries) | |||
Find last cell in a column, Delete its contents and make it active | Excel Worksheet Functions | |||
Find last cell in a column, Delete its contents and make it ac | Excel Worksheet Functions | |||
Removing Asterisks from the contents of a cell | Excel Worksheet Functions | |||
Delete asterisks from text in cells? | Excel Worksheet Functions |