We help IT Professionals succeed at work.

excel convert format issue

Wilder1626
Wilder1626 asked
on
Medium Priority
363 Views
Last Modified: 2012-06-21
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
Comment
Watch Question

>>>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
CERTIFIED EXPERT

Author

Commented:
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.
Ok Give me a short while

Sid
CERTIFIED EXPERT

Author

Commented:
No problem.

Thanks again. Really appreciate
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
CERTIFIED EXPERT

Author

Commented:
OK, let me try this.

CERTIFIED EXPERT

Author

Commented:
Oh! this is so good.

Thank you so much.

I take it.

Thanks again for your help
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.