delimiters

  1. littlefish

    Convert Text to Columns (Cells Include Line Breaks)

    I have a single column of several hundred rows of data that I would like to use the "convert text to columns" wizard, however, in addition to typical delimiters (i.e. "," and ";") these cells contain line breaks. When I run the wizard, the result is a single column of data to the point of the...
  2. J

    Delimiters within a field ...

    This may be a silly question but as a relative novice to spreadsheets I'm having a bit of a problem. I have a spreadsheet which I need to save as a .csv file so that I can upload it to an online application ... but the online application requires the .csv to use commas (,) as the field...
  3. V

    Multiple csv file importer

    Hello, I am trying to come up with a macro that imports multiple csv files to different sheets and using the name of the file as the sheet name. I also need to be able to select the delimiter and also Consecutive delimiters. I have found 2 variants, one that imports multiple files but does not...
  4. H

    Text to Columns with multiple delimiters

    I wonder if you can help. I have been tasked with extracting text from a CSV download from an app of a list of standard responses. As a download these contain multiple strings of characters such as: <p>Hello {{ entity.person.display_name }}</p><p><br></p><p>Thank you for your...
  5. K

    Simplifies the delimiters

    Hi, all I try to simplify my data which has an uncertain number of delimiters. sample data as follows A1 : one-two--three---four----five----- the results I expect are like this B1 : one-two-three-four-five thanks in advance
  6. S

    How to edit all queries/connections from one delimiter to another?

    In my Excel file, I have imported many txt files with tab delimiters manually (Data tab -> Import data -> From Txt). Each txt file is imported into its own separate sheet. The delimiters are recognized and the data within each txt file is neatly imported into separate columns, as shown in the...
  7. D

    Delimiter Dilemma

    Hi All, How do I add an "Oxford" comma? From the example below, the formula =SUBSTITUTE(REPLACE(REPT(", "&A2,A2<>"")&REPT(", "&B2,B2<>"")&REPT(", "&C2,C2<>"")&REPT(", "&D2,D2<>"")&REPT(", "&E2,E2<>"")&REPT(", "&F2,F2<>""),1,2,""),", "," and ",MAX(1,COUNTIF($A2:$F2,"?*")-1)) works but does not...
  8. S

    Return right-most text in a string with multiple delimiters using functions...

    Hello, I am trying to stay out of VBA. Just want to return the last bit of text.. firstbit\secondbit\lastbit delimiters will always be \ but could be many. Just need that last bit after the last \. Thanks in advance!
  9. P

    Is there a way to count delimiters before a text-to-columns is performed on a paste event?

    Hello, I have a sheet that data is being pasted in to and it should contain 57 fields, so 56 delimiters, in this case a comma. Is there a way to have VBA code to count the number of delimiters that are in the data on the paste event and display that number? I need to check this because it is...
  10. B

    Adding delimiters

    Not sure if this is an Excel question per se, but hopefully someone can point me in the right direction. I have received two txt files, lets call them “F” and “P.” F contains 1372 lines each with approximately 330 characters (including spaces). P contains 302 lines each with approximately...
  11. C

    Setting Custom Delimiters for Importing Text into Worksheet

    I have lengthy text in an MSWord document I need to import into an Excel worksheet. This body of text needs to be distributed across 5 columns, then begin new rows. The text is such that there are line breaks occurring within text intended for each cell, so I need for Excel to ignore line...
  12. V

    How to Make a CSV with HTML content EXPORTABLE to MYSQL - CSV_LOADDATA [self solved]

    I could not solve the above task, and i wanted to post a query on excel forum. But then i thought lets try once more changing delimiter AND I CAME BACK WITH SOLUTION for MY OWN Task. Anyway here it is (what i typed here before)...
  13. F

    Replace comma with pipe in .csv file

    I have searched the internet but have not find the proper solution; however it seems that several users have the same problem. My current client receives a .csv comma delimited files from the source. In these files, some fields contains commas that appear in a text file in double quotes. Editing...
  14. K

    Find text between delimiters in a cell and extract text between the following delimiters

    Hi, I've spent months trying to research a solution to my problem and after reading another post from your site that was very helpful for a different issue, I thought maybe you can help me. In A2, there are a list of headers followed by descriptions, one-after-the-other. For example, I have...
  15. Fishboy

    VBA - Import CSV - Delimiter issues

    Hi guys, I have been working on a VBA macro to import a CSV file into Excel 2010. On the whole it has been successful with most CSV files however with one particular batch the first "column" looks like this item:45758:0:0:0:0:0:0 As such Excel is insisting on breaking the data up using...
  16. E

    Import Delimited Text File

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

    Combining 2 cell vaules -- without losing data

    Good afternoon all- I have a data set that I'm trying to sort in order to be efficient for some of my team members. Below is an example of the raw data and how I've currently got it sorted. I think my problem may be that I am trying to join a number with a string but I'm not positive. Any...
  18. G

    Use a formula to set delimiter in text to columns?

    Hi there I'm using text to columns to split some data. My delimiter is a comma, but the problem is that there may be a random comma in the string that I don't want to use as a delimiter (ie it's not consecutive). There is a pattern to what I want to use as the delimiter - it is number,space -...
  19. R

    Splitting text into the row below with changing delimiters

    Hi, Was wondering if someone could help me at all? I have the following in an excel sheet. Column A Software defect;#19 Software defect;#19;#Capacity;#2 Software defect;#19;#Capacity;#2;#Monitoring & tools;#14 What I'd like to do is: 1) remove the # and number i.e. #2, #14...
  20. H

    Splitting/reforming groups of variable sizes using formulae – is this scenario possible with Excel or VBA.

    <TABLE class=MsoNormalTable style="MARGIN: auto auto auto 5.4pt; WIDTH: 477pt; BORDER-COLLAPSE: collapse; mso-padding-alt: 0cm 5.4pt 0cm 5.4pt" cellSpacing=0 cellPadding=0 width=636 border=0><TBODY><TR style="HEIGHT: 12.75pt; mso-yfti-irow: 0"><TD style="BORDER-RIGHT: #ece9d8; PADDING-RIGHT...

Watch MrExcel Video

This Week's Hot Topics

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
Top