- Hot Topics
Excel Change the lenght of the character
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 Column C AB_1234 AB1234 AB01234 AB_01234a AB01234a AB_012345 AB 01234 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 by Venus_excel; Dec 23rd, 2013 at 01:03 PM.
This question generated 25 answers. To proceed to the answers, click here.
This thread is current as of December 23, 2013.
For more resources for Microsoft Excel:
This article includes the following tags:
- Microsoft Excel