![]() |
#20
|
||||
|
||||
![]()
Hi Greg
I've stuffed it up if 'test' and 'SINGLE item' got highlighted. That was not the intent. Based on what the OP asked for, I was coding it to only start looking either way if it found a 'word' with at least one digit and letter. If it happens to have a dash at either end then it should extend the selection if the other side of the dash is letters and/or digits. On those parameters, I would expect to intentionally exclude NNN-123 but catch NN1-123 and NNN-1N2. I would also expect to get most of N1000-2.2 but exclude the other side of the decimal (.2). I think the code options are all available for the OP so he can do testing and work out exactly what he wants in and out.
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
Tags |
numeric, phonetic, word macros |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
rehahm | Word | 4 | 10-07-2015 10:20 AM |
![]() |
shansen | Word | 1 | 03-11-2014 12:43 PM |
Look up cell values with mixed number and letters | Cardinal2 | Excel | 1 | 02-10-2013 01:40 AM |
![]() |
trew | Word | 7 | 11-21-2012 12:54 AM |
![]() |
tanababa | Word | 1 | 04-28-2011 01:35 AM |