delimiter

I got dates on excel in general format form. I want to format them to actual dates. I tried formatting them as dates but they stay the same so it doesnt work. I read about delimiter but I tried it and that doesnt work either or maybe I'm not doing it right. ANyway here are the dates: 31.03.14...

i need formula OR VB CODE to put ^ delimiter to the text below EG--TEXT IN EXCEL = Comprehensive Insurance CI25874567 4000 1 Year richard Pendergast 101 Delia St OUTPUT ---Comprehensive Insurance ^CI25874567^ 4000 1 Year richard Pendergast 101 Delia St

Hi All, I have a number of very large files that I need to split up based on specific delimiter lines in a given cell. However the delimiter is not a uniform number of lines apart. The basic format of the file is: <delimiter line> <Name line> <Text Line> ... <Text Line> <Delimiter line> With...

I had a query that ran perfectly for months until I installed an Office 365 update yesterday. I am now getting an error that 'This query is too complicated to run'. I stepped through my query and the error appears when I split the column by a delimiter. After some trial and error I noticed that...

I am looking for a way to use power query to split column by delimiter without it automatically changing the new column type based on what it contains - I want it to remain as 'any' for data type. The reason being, I have an input box that takes in bits of information separated by commas, and...

I have a strings of data that often look whats below, I can isolate the first segment and the last segment...but I can't get the middle segments. The number of spaces can vary and it's turning out to be a nightmare. Forums/Google haven't yielded results (I may be looking for the wrong thing)...

Hello there. As it is probably obvious, I am super green on attempting VBA. But since I have some time, I have been exploring it to streamline processes at work. Here is a small background about my dilemma: My userform is going to be used to grade employee training with the results being added...

Has anyone done this? I've been googling for a while and haven't found anything apart from messing with your system settings and changing them back afterwards. I need to export the whole sheet to notepad using # as the delimiter I can't use , as the sheet contains a lot of text which uses ...

Hi, quite often I get spreadsheets containing product numbers - however, they often have a "#" as delimiter followed by a three letter option code. The data can come in a any column and vary from 5 to 1000 rows. So, I wan to make a permanent tool where I can select the column with the specific...

I have a code that convert files in folder from .txt (with "|" separator) to xslx, But the code works fine for some files (when I open it in excel), the others are wrong, when I try to import the wring one manually by excel ribbon(Get external data -- > from text), the files are correct. This...

Formula Challenge! This one is out of my league. For an ASAP work project, I need to extract an a physical address (including multiple spaces) from a single cell, with two different (but same) delimiters on either side, and drop into new columns. See example below. I've tried two different...

Dear gurus, I need to convert txt into excel, I have large amount of txt file that need to convert into excel which has delimiter (eg, comma, tab, or pipeline ("|"). My requirement is to have txt file on one folder and the converted file in another folder. My idea is: 1. Declare the folder...

I have a text file that looks something like this: 1147-1 SYRUP: DR.PEPPER 5GALLON/BOX 1653-1 SYRUP: DIET DR.PEPPER 5GAL/BOX 2011-2 WATER DISTILLED 6 / 1 GA 1217-2 ALL PURPOSE RASPBERRY FIL 40# 1273-1 STRAWBERRY PIE FILLING 38# 2893-1 BREAD: SOURDOUGH 12/1# OVAL 2287-1...

Salutations!! I'm looking for a solution to this problem in vba. I'd like to take data from the chart below which is in sheet 1.... <tbody> First Name Last Name Number of Tickets Ticket Numbers Annie smith 1 1 Mari jones 2 2;3 Steve smith 3 4;5;6 Nick jones 4 7;8;9;10...

Hello, I have a problem when opening CSV files and the data is all jumbled. I would like to open the file and have the data sorted like 'text to columns' but without doing it manually. I did create a macro to remove the delimiter but I need to simplify the process even more. Any help is...

So i have a dataset from a vendor that is many different models of printer ink. Here's an example: <tbody> Brand Series Models price OEM# TYPE COLOR Brother Fax <tbody> 1840C, 1940CN, 2440C, MFC210C, 420CN, 620CN, 3240C, 3340CN, 5440CN, 5840CN </tbody> 2.99 <tbody> LC41BK </tbody>...

This has been an ongoing problem that I can not figure out. Every time I open a file in excel (.txt or .csv) with html script, it parses the script as well as the columns. These files are coming from an outside source so I do not have the liberty of asking them to use a different delimiter to...

Hello, I was able to find the below code for a custom function to read a cell and pull back the delimited value to a cell. Function ExtractElement(str, n, sepChar) ' Returns the nth element from a string, ' using a specified separator character Dim x As Variant x = Split(str...

Hello, I have a column of data with the fields separated by differing combinations of commas, semi-colons, multiple spaces and tabs. The only thing the separations have in common is that they all incorporate more than one space. I would like to use the text to columns feature to separate the...

Hi I've had a search through but not found a specific answer (yet) for a resolution to my issue. Here is some data I'm working with (don't worry about spelling in data it's how image to text sees it right now): 2013/07/23 04:23:00 0 p 606 31,89 Talon 2013/07/21 20:36:36 0 p 600 31,149...