separating data

  1. P

    Stuck, Need Help (please). Trying to export unstructured text from PDF to import into Excel separating/placing text into specific columns

    Hello, I'm hoping someone can help with this work project. I have experience with formulas and pivot table and am somewhat familiar with Power Query but apparently not enough for it to help me with this work project. I've been trying to find an Excel work-around for this project to simplify it...
    • phbalanced
    • Thread
    • data clean up excel export import office 365 pdf power pivot power query separating data structured data unstructured data
    • Replies: 0
    • Forum: Power Tools
  2. T

    Help separating multiple data from one cell to individual row

    I don’t know what to call this, but someone has had to have done this before. Sorry if I’m searching for the wrong words on here, but I can’t find the answer. Thanks for your help in advance. I’m getting a data dump of random contact information, most of it I can sort pretty easy except the...
    • thekodak
    • Thread
    • bob row row and column sorting separating data smith
    • Replies: 1
    • Forum: Excel Questions
  3. A

    CNC Data Import

    I am in need of help to write a macro for importing data from a txt file automatically, and to separate the data into multiple columns by a specific cell input. The only problem is that my txt file imports as a single column and the data isn't exact same amount of rows. So I would like the VBA...
  4. E

    Macro to separate data from single worksheet to multiple worksheets

    Hi there!</SPAN> I have a large amount of data that is all contained in a single worksheet. I am trying to create a macro to separate the data according to name in Column A, then place each block of data with a different name in column A in a separate worksheet in the same workbook. For example...
    • EverClear
    • Thread
    • macro multiple worksheets separating data splitting data vba
    • Replies: 1
    • Forum: Excel Questions

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
Back
Top