Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() Hi, I have a list where some entries are preceded by 5 spaces, others by 7 spaces. When I try to custom filter this list to only display those that begin after 5 spaces by filtering to; 'Does not begin with ¦ <7 spaces*' It doesn't display any entries from the list. When I go back to the filter it has automatically udated it to; 'Does not contain ¦ *' I need to keep the list in order so I cannot sort it. Any ideas?? Thanks in advance, Steve -- steev_jd ------------------------------------------------------------------------ steev_jd's Profile: http://www.excelforum.com/member.php...o&userid=33107 View this thread: http://www.excelforum.com/showthread...hreadid=569919 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Remove trailing spaces from multiple columns in Excel | Excel Worksheet Functions | |||
spaces not recognized as spaces | Excel Worksheet Functions | |||
Suggested new functionalities for Filters, Pivots and other issues | Excel Discussion (Misc queries) | |||
Suggested new functionalities for Filters, Pivots and other issues | Excel Discussion (Misc queries) | |||
COUNT THE NUMBER OF LETTERS INCLUDING SPACES IN A CELL? | Excel Worksheet Functions |