Microsoft Office Forums - View Single Post - [Solved] Take String of numbers, expand ranges, sort, then compress back into ranges

Thread: [Solved] Take String of numbers, expand ranges, sort, then compress back into ranges

View Single Post

Old

07-21-2016, 04:34 PM

gmaxey

gmaxey is offline

gmaxey uses Windows 7 32bit

Windows 7 32bit gmaxey uses Office 2010 (Version 14.0)

gmaxey uses Office 2010 (Version 14.0)

Office 2010 (Version 14.0)

Expert

Join Date: May 2010

Location: Brasstown, NC

Posts: 1,429

gmaxey is a jewel in the rough

gmaxey is a jewel in the rough

gmaxey is a jewel in the rough

gmaxey is a jewel in the rough

Default

Andrew,

I'm dealing with that at the start:
strNumberList = fcnKillWhiteSpace(Selection.Text)

... which probably should include en and em spaces just to be complete.

__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/

Reply With Quote