Venus_excel
Board Regular
- Joined
- Dec 18, 2013
- Messages
- 74
Hi all,
Happy to see u again all.
Need your help here. Thanks in Advance.
here i need to change the character length in macro.
example
<tbody>
</tbody><colgroup><col><col></colgroup>
Hint :
1) _(underscore) should come at third character
2) Total character of output is 8 character
3) After _(underscore) if it is four character then 0 will come after underscore(_) and if it is five character then 0 wont come.
Please help me to sort out this.
Happy to see u again all.
Need your help here. Thanks in Advance.
here i need to change the character length in macro.
example
Column C | Output(same in column c) |
AB_1234 | AB_01234 |
AB1234 | AB_01234 |
AB01234 | AB_01234 |
AB_01234a | AB_1234a |
AB01234a | AB_1234a |
AB_012345 | AB_12345 |
AB 01234 | AB_01234 |
<tbody>
</tbody><colgroup><col><col></colgroup>
Hint :
1) _(underscore) should come at third character
2) Total character of output is 8 character
3) After _(underscore) if it is four character then 0 will come after underscore(_) and if it is five character then 0 wont come.
Please help me to sort out this.
Last edited: