![]() |
#2
|
|||
|
|||
![]()
I've managed to find a solution, so in case anyone else ends up in the same situation here it is.
I did a find/replace for "zxc. [" > "ZXC. " The sort doesn't distinguish between capitals so everything is properly sorted after that. I then can do a search matching case to replace the opening bracket. I still don't know why hiding the text didn't work, but this workaround solved that problem. |
Tags |
hidden text, macros, sort text |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
tectonicseer | Excel Programming | 1 | 07-27-2014 11:54 AM |
![]() |
Ulodesk | Word VBA | 2 | 06-19-2013 08:46 AM |
![]() |
zulhfreelancer | Excel | 1 | 06-14-2013 04:12 PM |
![]() |
christie | Word | 1 | 08-17-2011 09:10 AM |
CAUTION!! Sorting a spreadsheet with hidden columns will trash your data. | psmaster@earthlink.net | Excel | 0 | 11-24-2009 11:54 AM |