americanuser2016
New Member
- Joined
- Oct 10, 2016
- Messages
- 3
Hi, I need help from an expert. I want to extend a range of numbers with text prefixes using a VBA. It's better if I use an example:
<tbody>
</tbody>
The text prefix can be any text and ranges from 1-4 letters, but the prefix is static for that row. There is also an undefined number of variables in the input column, there can be as many as 1000+ numbers. I separated the input and out put columns for clarity, but I actually want the output data to overwrite into the same column as the input.
Input Column | Output Column | ||
R1,R2-5,R9,R10,R12-13 |
<tbody> </tbody> | ||
<tbody> </tbody> |
<tbody> </tbody> | ||
<tbody> </tbody> |
<tbody> </tbody> | ||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody>
</tbody>
The text prefix can be any text and ranges from 1-4 letters, but the prefix is static for that row. There is also an undefined number of variables in the input column, there can be as many as 1000+ numbers. I separated the input and out put columns for clarity, but I actually want the output data to overwrite into the same column as the input.