| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search for 6 Character value
Hi, I am trying to design a macro that will search for values in a column
that are 6 characters long. Data is text that looks like numbers (downloaded from a mainframe). I tried using a search with 6 *'s but it just returned everything. Any suggestions? Thanks Marc |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Search for 6 Character value
How about searching for ?????? (6 question marks)
* means any set of characters ? a single character Make sure you specify lookat:=xlwhole in your code. MFINE wrote: Hi, I am trying to design a macro that will search for values in a column that are 6 characters long. Data is text that looks like numbers (downloaded from a mainframe). I tried using a search with 6 *'s but it just returned everything. Any suggestions? Thanks Marc -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Search for 6 Character value
Duhhhhhh. I can tell this has been a long week. Thanks
Marc "Dave Peterson" wrote: How about searching for ?????? (6 question marks) * means any set of characters ? a single character Make sure you specify lookat:=xlwhole in your code. MFINE wrote: Hi, I am trying to design a macro that will search for values in a column that are 6 characters long. Data is text that looks like numbers (downloaded from a mainframe). I tried using a search with 6 *'s but it just returned everything. Any suggestions? Thanks Marc -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| search a column for a character.. | Excel Discussion (Misc queries) | |||
| Character Search. | Excel Worksheet Functions | |||
| search more than one character | Excel Worksheet Functions | |||
| How do I search for more than one text character in one cell? | Excel Worksheet Functions | |||
| Is it possible to search for the "?" character | Excel Worksheet Functions | |||
Linear Mode
