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 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
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.

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