| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
(in)definite article and leading/trailing space remover needed
In order to better alphabetize a books database, I would like to use a macro that checks for and deletes all titles that BEGIN with "The", "An", "A", etc. IOW, if the first word in the cell is an (in)definite article. It would help if this SAME macro did a pre-scan for leading and trailing spaces, and deleted them accordingly. Finally, this macro would be most convenient if worked after selecting a column. Thx for any input you can provide on creating such a macro! -- KHashmi316 ------------------------------------------------------------------------ KHashmi316's Profile: http://www.excelforum.com/member.php...o&userid=10439 View this thread: http://www.excelforum.com/showthread...hreadid=378854 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Removing leading and trailing space... | Excel Discussion (Misc queries) | |||
| Formatting numbers with leading and trailing zero's | Excel Worksheet Functions | |||
| Excluding only leading or trailing cells from a column | Excel Worksheet Functions | |||
| Removing leading/trailing spaces | Excel Discussion (Misc queries) | |||
| leading or trailing quotes | Excel Programming | |||
![KHashmi316[_8_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
