delimeter

  1. G

    Parse dates into comma delimit values

    Greetings Excel Community, I have a set of data and i am wondering if there is code or formula that can be created to parse these values into comma delimited dates. The dates are combined together to make it look as a long string, however i am attempting to create the end result under the...
  2. C

    Creating a new sheet with data that is merged to one cell per row

    Hello, I've been struggling with what I thought would be a basic Macro, would appreciate some guidance if possible. Our CRM spits out an excel sheet of hundreds of rows similar to the one below. Unique Item Number Item Item Description Code Quantity Units Value Currency Weight Weight 2...
  3. Jyggalag

    Text to columns issues

    Hi all, I currently have a very messy sheet that looks like this: Essentially, row 1 is the heading, row 2-3 is the results that I want to produce through a text to columns, and rows 24-45 are the data that I currently have. The issue is that my cells have become messed up, so for every...
  4. T

    Split string without delimiters

    Greetings, I am analyzing protein sequences, and wanted to use Excel's tools to facilitate the analysis. For that, I wish that all amino acids (1-letter abbreviation) occupies its own cell. The main problem is that the sequences come without any delimiter, and they can be quite long (hundreds...
  5. M

    Convert Bar and Comma Separated Values into a single row with one record per cell...

    I have example data that is structured as the below with aggregated values on the end in one cell. I'm hoping to split this out into each record if it is split with a comma, space or pipe. The intended output of it would be to use vba to show it the column with the separated values and then have...
  6. S

    HELP with data delimiters

    Hi, I have long list of files in .dat format that I want to convert them into excel format. The files have bunch of data separated by delimiters and I need them to be separated by columns in excel. I know the excel trick where I can import the data in excel/or open with excel and use the...
  7. M

    Multi select ListBox

    Hi, I was able to return multiple values into one cell; however, I am trying to figure out how to change my delimiter from"," to Char(10): For i = 0 To DEPListBox.ListCount - 1 If DEPListBox.Selected(i) Then 'If selected is True strTemp = strTemp &...
  8. C

    Importing a CSV file with ws.QueryTables.Add

    Hello, Im having trouble importing a csv file. The first row works fine, but the rest are all wonky. Here is a sample of the first and second row from the csv: "Order # ","Purchased From (Store)","Purchased On","Bill to Name","Ship to Name","G.T. (Base)","G.T. (Purchased)",Status...
  9. J

    How to stop a value convert to date after using Text to Columns feature in Excel 2010?

    let's say I have a cell A1 contain 2 values input as (1,3/4), I want to separate the values into other columns like B1 (1) and C1 (3/4) using the Text to Columns delimited feature. However, it keeps showing me as C1(4-March) even though I formatted original cell to text format already...
  10. G

    Splitting cells with 2 delimiters "; and |", can it be done?

    Hi This is my first post. I hope that it makes sense. I export a sales csv from my website which contains all the address information for the various couriers that I use. Recently orders overseas have increased and I am forever filling in CN22 forms, so I decided to also export out item...
  11. A

    Split Names In One Cell to Multiple Columns

    I have an output that puts multiple names into one cell. The names are in the format "LASTNAME, FIRSTNAME, LASTNAME2, FIRSTNAME2...) I need to split the names up and with first and last name separated by a comma, I can't use the delimiter as a comma. How can I approach this? Any help is...
  12. Q

    CSV Export

    I have an excel sheets which contain information which will be exported via CSV in Excel and later be imported via CSV into a mysql database. The problem is that some columns in the excel can contain quite a few common delimiters such as commas, apostrophes for text fields, along with single...
  13. A

    Importing a Text File with Complex Structure

    Hello everyone! This is my first post and it has been a rough few days trying to make this work. I run reports that tell me when an individual is supposed to be in the office and when they actually log in, but this is a manual process where I have to go through several hundred people each...
  14. L

    Custom Delimiter in Excel 2007

    I am quite comfortable with Excel, and have used this for years. I perform a lot of text manipulation, often taking data from external sources and pasting into new worksheets. I used "(" as a delimter once about a month ago, but now I've found in ANY new file I create or new data I paste into a...

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