delimited data

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...

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...

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...

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...

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...

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...

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...

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...