delimiters

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

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

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

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

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

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

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

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!

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

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

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

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

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

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

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

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

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

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

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

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