Harry_1234
New Member
- Joined
- Aug 19, 2017
- Messages
- 47
Hello,
Looking for a VBA script that would extract numbers in a range to a separate column. Attaching a screen-shot of various possibilities of ranges. Below is an explanation of diff set of groupings that would like expanded into individual numbers.
\+1234567891[01234567] - Anything in brackets is what is to be included i.e. this would be expanded to \+12345678910, \+12345678911, \+12345678912, \+12345678913, \+12345678914, \+12345678915, \+12345678916, \+12345678917
\+1234567891[1-2] - This would mean 1 to 2 so this would expand to \+12345678911,\+12345678912
\+123456790XX - The XX would be wildcard in last digits that would represent 00-99 so this would include all the numbers from \+12345679000 to \+12345679099
\+12345677[6-8]XX - This is a combination of grouping and wildcard so the last 3 would be 600 - 899 and the numbers to be \+12345677600 to \+12345677899
Looking for a VBA script that would extract numbers in a range to a separate column. Attaching a screen-shot of various possibilities of ranges. Below is an explanation of diff set of groupings that would like expanded into individual numbers.
\+1234567891[01234567] - Anything in brackets is what is to be included i.e. this would be expanded to \+12345678910, \+12345678911, \+12345678912, \+12345678913, \+12345678914, \+12345678915, \+12345678916, \+12345678917
\+1234567891[1-2] - This would mean 1 to 2 so this would expand to \+12345678911,\+12345678912
\+123456790XX - The XX would be wildcard in last digits that would represent 00-99 so this would include all the numbers from \+12345679000 to \+12345679099
\+12345677[6-8]XX - This is a combination of grouping and wildcard so the last 3 would be 600 - 899 and the numbers to be \+12345677600 to \+12345677899
