Most valuable professional
  • 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:

  • Excel
  • Microsoft Excel