| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
remove cells with one digit
Hi, How do I program vba to remove/delete the values in cells with only one digit? I want to search through the entire workbook and to delete the cells with one digit. Thanks -- Sethaholic ------------------------------------------------------------------------ Sethaholic's Profile: http://www.excelforum.com/member.php...o&userid=25113 View this thread: http://www.excelforum.com/showthread...hreadid=388107 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
remove cells with one digit
Only one digit means only one character and it's numeric, or mixture of
text/numbers where only one numeric character is present? Tim -- Tim Williams Palo Alto, CA "Sethaholic" wrote in message ... Hi, How do I program vba to remove/delete the values in cells with only one digit? I want to search through the entire workbook and to delete the cells with one digit. Thanks -- Sethaholic ------------------------------------------------------------------------ Sethaholic's Profile: http://www.excelforum.com/member.php...o&userid=25113 View this thread: http://www.excelforum.com/showthread...hreadid=388107 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I remove the leading 1 from a nine digit telephone # | Excel Discussion (Misc queries) | |||
| How can I remove 5 digit from a string ? | Excel Discussion (Misc queries) | |||
| remove and replace a digit... | New Users to Excel | |||
| Color a single digit in a mult-digit number cell | Excel Discussion (Misc queries) | |||
| When we enter a 16 digit number (credit card) the last digit chan. | Excel Discussion (Misc queries) | |||
![Sethaholic[_15_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
