asked on

excel convert format issue

Hello all,

I have a big issue with an excel format, copied from the web.

In the excel spreadsheet, you will see that in sheet "Original", this is the web format when i paste in excel.

But know, i need to create a macro that will convert that like the example that i have in sheet " Convert report " just by clicking on the convert report button.

Is that something feasible?

How can i do this?

Thanks again for your help.

Classeur1.xlsm

SiddharthRout

>>>But know, i need to create a macro that will convert that like the example that i have in sheet " Convert report " just by clicking on the convert report button.

No a macro is not required :) But I can still make one of you want. If you want to do it manually then do this.

Select Col A and then

Excel 2003
Click on menu Data~~> Text To Columns~> Fixed Width. Click Next and then click Finish

Excel 2007/2010
Click on Data Tab~~> Text To Columns~> Fixed Width. Click Next and then click Finish

Hope this helps :)

Sid

Wilder1626

ASKER

Hello SiddharthRout

Thanks for your help.

I was actually did manually but i would really love to have this has a macro if it's possible.

Thanks again.

SiddharthRout

Ok Give me a short while

Sid

Wilder1626

ASKER

No problem.

Thanks again. Really appreciate

ASKER CERTIFIED SOLUTION

SiddharthRout

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Wilder1626