delimiter

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

This one is rather tricky I am assuming... I have data that I need separated by an array of text and can be done in VBA if needed (note that it will be done for 1000's of lines and cycle time is a concern). I need to split the following data: 01609 0805ZG106ZAT 03041 C2012Y5V1A106Z ZZT09...

Hi, Please help me ! Few years ago there was some discussion on this forum (http://www.mrexcel.com/forum/showthread.php?134185-xlCSV-comma-Save-As-CSV-semicolon-delimited&highlight=csv+semicolon ) about the problem that I have but I hope that my problem deserves a new thread because it is...

Hi there. I frequently review DAT files. These DAT files use a variety of characters as delimiters. I'm trying to devise a macro that will perform a text-to-column operation, using the content of a specified cell as the delimiter. Here's my code, which uses þ (ASCII 0254) as a delimiter...

I am currently using MS Office Excel 2007 and my limited VBA knowledge has put me at a stop of a project that I have been working on. I am trying to create an excel template that will open every word document in a specific folder and pull data (open to suggestions as to how this would work)...

Hi there, Having some problems splitting data within a single column into several using VBA rather than a Formula. (I have been able to get working using a formula). I have found a few similar theads but nothing i seem to be able to convert with my some what limited skills :( My data is...

I'm importing a text file via VB using a recorded version of the "import external data" routine. The data consists of dates and times but they're stored with "." rather than "/". So I used find/replace to switch the "." for "/" and all was okay, unless there's a possibility of interpreting...

Hey all, I have a list that looks like this: AVERNA,ROBERT C H/E Corn,Marlin Calvin LIV CATANESE,SALVATORE J & OLGA M JIMENEZ,ALEJANDRO & HILDA M Cortes,Alessandra M Marquez CATANESE,SALVATORE J & OLGA M & Nunez, Jason P The conditions: * If comma delineater between last and first name and...

I have thousands of lines of data that are of the following form: Jackson, TN 9623 BCBS TN 98 UnitedHlthCare 2<o:p></o:p> Jacksonville, FL 3577 Aetna 47 BCBS FL 37<o:p></o:p> Knoxville, TN 3796 Cariten 44 John Deere 41<o:p></o:p> Lakeland-Winter Haven, FL 2165 UnitedHlthCare 31 Aetna 29...

Does anyone know the syntax to convert text to table using 2 delimiters (~ to switch to the next column and "&" to switch to the next row)? I'm planning to use it as part of a macro for MS Project 2003 but I figure it would be pretty much the same in excel. Any help would be greatly appreciated.