delimited string

Here's the problem: I have a large spreadsheet filled with data across columns A:J. Each cell in each column contains a single value, EXCEPT columns F:H, which contain delimited data. I need to split these cells into multiple rows so that each row in the spreadsheet is unique and each cell has...

I have a lot of field data in a row that's in format: Color: Red|Title: Red Shirt|Date: 2015|Medium: cotton|Size: M| Title: Blue Dress|Date: 2014|Price: 55|Size: M| Color:Green| Type: New| Size: G| Title: Green Shirt| Here, in my data, there are many rows with new fields. There are many...

I have reviewed several similar topics and there is something I am definitely doing wrong. I have a worksheet called "ShipDtls" that contains data. I want the last row, columns 16 thru 20, data split (see link w/example: ) {link...

Replace, delimit macro for x,y coorinates Hi I am trying to create a macro that will allow me to replace ( , ) on several x,y coordinates and convert them into separate columns at once. For example my villages opponents as you can see I have a list of villages that i want to insert into...

Hi all, Want to import a text file in excel via macro, however I need it to do two things - first I want to select a text file (as the name changes every day) & secondly I want it to be imported with delimiters '|'. Currently I have something as mentioned below, however the below code only...

Hello - I have 65 rows of data; each cell contains anywhere from 5 to 8 comma delimited values that need to be housed in their own rows. Here is an example of my data: Cell A2: 0x460297gpr,9806458rtgjd,0x5641313746fd,9x44564fs4f5s4f5ds3,5x4f35sd4f3sd4f3s Cell A3...

I can do this but it would be long than it should be. Each cell is semi-colon delimited and I could change it to a comma or anything. The problem is that the child must have all the same properties as the parent plus the values of the child and I thought a UBound would work. like this: Code...

Hi All I am trying to extract 3 numbers to separate cells, which are outputted into an excel sheet in the form "A / B / C" (where A B and C are 1 or two digit numbers). Due to the spaces between the "/" delimiter I can use the LEFT and RIGHT functions specifying that 2 digits are to be returned...

Hello, I have a question about separating a text column by commas. So If my column has 12 characters I would like to know how to add a comma every 4 characters. Regardless of how many characters that there is?

Problem: String is broken into 2 parts within a delimeter. Goal: To keep each String/Segment in tact regarless of Alpha/Numeric. I have a .csv file with 26 segments (commas). This file contains customer data: PO#, Order#, Carton ID, Address 1, Address 2, Address 3, etc. I've written code...

I have a "+" delimited string in a single cell that needs to be added together (i.e. "2+.25+1+0.4" should be 3.65) however I'm having problems because of the numbers contain decimals. I was using this formula but it only works with whole integers. =IF(ISNUMBER(SEARCH("+",M2))...