![]() |
|
|
|
#1
|
|||
|
|||
|
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 |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
VBA to keep hidden rows hidden when filtering
|
tectonicseer | Excel Programming | 1 | 07-27-2014 11:54 AM |
VBA is objecting (no pun intended)
|
Ulodesk | Word VBA | 2 | 06-19-2013 08:46 AM |
Add Standard Prefix To Cells
|
zulhfreelancer | Excel | 1 | 06-14-2013 04:12 PM |
Hidden style applied over already-hidden text.
|
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 |