Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 05-19-2015, 01:55 PM
bookie bookie is offline Sorting with hidden prefix not working as intended Windows 8 Sorting with hidden prefix not working as intended Office 2013
Novice
Sorting with hidden prefix not working as intended
 
Join Date: May 2015
Posts: 2
bookie is on a distinguished road
Default

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.
Reply With Quote
 

Tags
hidden text, macros, sort text



Similar Threads
Thread Thread Starter Forum Replies Last Post
Sorting with hidden prefix not working as intended VBA to keep hidden rows hidden when filtering tectonicseer Excel Programming 1 07-27-2014 11:54 AM
Sorting with hidden prefix not working as intended VBA is objecting (no pun intended) Ulodesk Word VBA 2 06-19-2013 08:46 AM
Sorting with hidden prefix not working as intended Add Standard Prefix To Cells zulhfreelancer Excel 1 06-14-2013 04:12 PM
Sorting with hidden prefix not working as intended 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

Other Forums: Access Forums

All times are GMT -7. The time now is 10:06 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft