text to column

I have several columns in an Access Table that I need to split into several fields. They are easy to "Delimit" as you would call it in Excel, with a "-" or a "." where I would need to split it. How can I accomplish this in Access? Another thing, I only want it to split the first "-", but no...

So, I get an SAP output from a SPOOL. It comes out as a terrible "|" delimitated .CSV file in multiple "pages" which are actually blank rows with "---------" in between and some other text. I have to clean it before importing it in to Access which I have a VBA script for. I have this code to do...

I have cells which contain multiple names, but they are separated by different values. I want to split these into separatae cells in the same row. E.g. I start with... Row 1 cell 1 = Mr Smith, Dr Jones Row 2 cell 1 = Dr Peter Dent/Professor Nick Dole/Jim Gomez I would like to finish with...

Dear friends, How do i add forward slash (/) between first word and numeric value. For eg. AFRAM/101; AES/151 <TABLE style="WIDTH: 452pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=603><COLGROUP><COL style="WIDTH: 452pt; mso-width-source: userset; mso-width-alt...

I am trying to separate a column that contains a company name followed by the street address in the same cell. Is there a way to separate these into two columns? The street address is not always the same number of characters from the left or right of the cell. Below is an example of how they...

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

Heyyyya folks! Been a while since I've been here, but I've been trying to find some information and not having any luck, so....here I be! :) I'm one of those people who loves keyboard shortcuts more than using the mouse, as a general rule. I use the Text to Column function on a regular...

I have a data sheet where the text is separated with the empty rectangle character and would like to replace it with semicolon to complete a text to columns. First, I used the ctrl+h function, but was not able to copy the character in the Find What field. I also tried pasting the character into...

All right . . . I have been bashing my head against a wall for two days now because I got interested in solving this issue. I have a cell that contains thousands of names in the following format: Smith MD, Bob; Savage DDS, Fred; Doe MD, Jane; . . . et cetera I have already fixed the issue...

I'm pulling data out of an html source. I am currently taking it out line by line. It looks : <table class="lined fontSize90" summary="This table shows the distribution of employer businesses by size of business establishment in each province and territory."><tbody><tr><td id="t3r3"...

Hello all, I am trying to format some data in a Table. The Column in question contains a part number and name. "Data[[#Headers],[Part]]" which is formatted like "124578 Part1" In the macro, I have split this delimited data at the space, and it works fine. "B1"="124578" and "C1"="Part1" The...

I have a worksheet with 1000+ unique company names listed in column A. A string of company executive names are then listed in column B (separated by semicolons) which corresponds directly to the company listed in column A. Similiarly, Column C (also separated by semicolons) contains executive...

Hello, I have an address string that I need to split up into three cells using vba with the split function. The problem that I'm having is that I can't seem to formulate the functions in which they can handle different forms of the address. For example, New York, NY 23658 should return New...

I have a data in A1 cell which is 'SDABCD' and I need to seprate/split this data as 'SD' in one cell and 'ABCD' in another cell. I have searched through the internet but could not find a suitable function. Is there a way I can do can the desired result without using 'Text to Column' function ...

Afternoon All, I have a macro or rather i recorded one for what i wanted to automate: Columns("A:A").Select Selection.TextToColumns Destination:=Range( _ "Table_owssvr_1[[#Headers],[Workstage]]"), DataType:=xlDelimited, _ TextQualifier:=xlDoubleQuote...

I am trying to convert cells (all in column D) which are separated by "~" into columns. Unfortunately, running the text to columns command on several rows at a time can cause Excel to panic with an out of memory error (error #7 etc.). The file is ~100mb and contains 500k-700k rows (I have 4GB...

Hi, This is my first posting, but I'm hoping you all can help: I am copying data from a PDF. The data I need is in columns, spread over hundreds of sheets. I would like the data in the same layout (columns), but need it in excel instead of the PDF sheets. I've tried copying and pasting into...