delimited data

  1. L

    Power Query: Cleaning Repeating Delimiters

    Hi there. I've been using PowerQuery to collapse a flat file into combined, multi-value cells with delimiters. The inconsistent nature of the raw data results in repeating delimiters / spaces, like so: ; ; Smith, Judy; Carson, Kevin; ; Levy, Kevin; Bloom, Judy; ; ; ; Nicholas; ; ; I'd...
  2. S

    Split cell, extract numbers, get difference

    Hi all, I’m looking for a formula where in i could separate numbers from a cell containing text and numbers and also find the difference between those 2 numbers. For eg: Runs scored by Mike 560 vs Richard 345 This is the actual text which i have a in a single cell however only need the...
  3. D

    Parsing a word document into a csv or other machine readable format

    Hi all, I have a non-delimited text file of health data called "2013_data.txt". This text file doesn't have any structure to it and the only way to structure it into columns and rows is to use the specified fixed length positions for each variable as indicated by the data dictionary...
  4. T

    Compare Two Delimited Lists and Determine if Values are the Same

    Hello, I am trying to come up with a function that compares two delimited lists to see if they are made up of the same values. Each list is in its own cell, can be variable length, and can have variable order. I'll give a few examples of inputs and outputs to display what I am trying to...
  5. M

    Delimit and create a loop in VBA for a varible number in each row

    Hi there, I have a data set where in column J and K I have data which is separated by ; - the data which is A-I is relatable to what is in these columns. I would like to delimit that data in both these columns which will have the same number of data elements in each and then create a line for...
  6. S

    Macro for delimited data

    Hi all, I am absolutely stumped on how to solve this challenge with a macro. I have software providing me with multiple rows of data, with all the data relating to a particular job placed in a single cell, separated by a semi-colon. An example is below. I basically need to develop a macro...
  7. D

    Parsing and combining delimited text

    I think this is a text to columns and then something else. The final result of what I am trying to accomplish is represented below. Letters in LOC1 and LOC2 are not important... random and represent a location. First in cell LOC1 is associated with the first in LOC2... and so on.... <tbody> ID...
  8. C

    Need Help : Creating Lists with IF Statements

    I want to start off by saying I'm suuper new to Excel and completely Self-taught mostly using these forum threads. I've hit a hitch lately and I need some assistance resolving my problem. I work for a Front Desk in Las Vegas. And I'm trying to make a report that auto-sorts information from...

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