| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to specify only if 3 characters or less
I download a report that has a column heading "Name" and is in column D. The
name is last name then a comma then a space then the first name, for example SMITH, FRED. I would like to write a macro that would generate a report to pull only the last names with 3 characters or less. That new report would be on a sheet titled, "Short Names". What I want to accomplish is having a sheet that lists all the 3 character last names or less from the main report called "All Records". Names like "Ray", "Fox", "Lee" or " Hu". Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert 5 characters in a cell to 6 characters by adding a zero | Excel Discussion (Misc queries) | |||
| Insert Leading Characters If String Is Only 7 Characters | Excel Discussion (Misc queries) | |||
| In Excel find characters when multiple characters exist w/i a cel | Excel Worksheet Functions | |||
| HOW DO I EXTRACT ALL CHARACTERS AFTER 5 CHARACTERS ON LEFT | Excel Worksheet Functions | |||
| What do these characters mean? | Excel Programming | |||
Threaded Mode
