align columns

  1. S

    save files in csv and then open them from location where files were saved to align data

    I'm trying to save first column of the each sheet as a separate csv file who's name depends on name of each sheet in work book. Once i'm done saving those sheets i want to open those files one by one to align the data in them. below is my code can you please assist how can i open files from same...
  2. P

    A trivial macro that recursively moves cells in a row.

    It is a trivial problem but I am so newie, sorry.. The Idea is that recursively with a for check the value of a columm if the value is "I" then I should cut some consecutive cells from that row and paste them in the same row but with some cells displacement... it is pretty much a selective copy...
  3. B

    Save a file as .txt & keep spacing

    I thought this would be easy. I can't figure out how to paste a portion of a worksheet so, here's what I have: A B C D E F 1 123 ABC 1 123 Joe Smith 1234 N. Elm 2 123 ABC Tommy Jones 59th Street When I save it as a .txt...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top