text to columns

  1. A

    parsing csv

    Hi all, I am converting a text file to a csv file. after converting, i run a text to columns to place the data in different cells. somewhere along the way, i seem to loose numbers that are in thousands. anyone have an idea why this might happen, or how i can avoid it? thanks, Az
  2. B

    Split a column with no delimiter

    I have a spreadsheet that has 2417 cells of web page id's in column A. (example:<table border="0" cellpadding="0" cellspacing="0" width="328"><tr height="17"><td class="xl24" style="height:12.9pt;width:246pt" height="17" width="328">crayons-pack-1004)</td> </tr></table> I would like to split the...
  3. N

    VBA text to columns

    Hello Forum, i would need your inputs related to a VBA code: the background is as follows - i have a text file that i need to automatically perform text to column operation. I have recorded the macro to do so but the problem is that it saves the file in a diferent excel file. what i would...
  4. G

    Need to change Range("A1") to refer to row 1 of active cell's column

    Dear All, I am trying to create a Macro which uses the Text to Columns feature of Excel. My problem is telling the macro the Destination of the output. When I execute the macro, I want it to: 1. Select the entire column of the active cell 2. Change the format of all the cells to Text 3...
  5. M

    Macros are changing functionality

    I am using a Macro to separate characters from a string in a cell using text to columns as shown below. Sub Separate() ' Columns("A:A").Select Selection.TextToColumns Destination:=Range("B1"), DataType:=xlDelimited, _ TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False...
  6. A

    Text to Columns to Rows via VBA

    Hello and thanks for looking at my question. I have table that has the following headings: Week, Date, Group, Item Codes Data example: 01 1/30/2011 The Group Item Codes The data in Item Codes is stored as such: item#1, item#2, item#3 with each item seperated by "," and " ". What I need to...
  7. B

    Import Data from results of a PHP Form Mail to Excel Spreadsheet

    I receive emails from our Form Mail page that clients use to register for our Fitness classes. They look like this....This is the exact way the information comes to me. <!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/>...
  8. K

    Extracting numbers (Coordinates) from string

    Hi: How can i leave only the coordinates and supress the text from the string next string: Command: ID Specify point: X = 5068.7648 Y = 224.3896 Z = -4063.3161 When i copy this from the AutoCad, it copies it the whole text only in the first cell (A1 for example) This is for a large...
  9. M

    Please help with data extraction from text!

    Hello, once again I am here to ask for your help. Thanks you folks in advance. I have spent almost all day trying to get this done but no success. Please help!<o:p></o:p> <o:p> </o:p> I have a text file that came from a web form. I have to convert this text (see shortened text below) to...
  10. J

    Separating text columns

    One of our systems spit out a report of first and last names. Instead of spitting out the report into 2 separate columns, it combined the first and last names into one column and separated the names with a dash (-) (i.e. "John-Smith" as one cell). Typically I would use text-to-columns, but...
  11. D

    Sorting/Converting Street Addresses

    I have street addresses in one column. Example 1234 E Fake St, Unit 102 I need to seperate the 1234 E into one column then the Fake St into another and then Unit 102 into it's own aswell. I know how to use Text To Columns but it will only allow me to use space with ends up with everthing in...
  12. D

    Splitting Text to Columns at change in case of text

    Hi I am looking for some help on splitting name text into columns and rows. I have text in a cell that looks like <TABLE style="WIDTH: 180pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=240><COLGROUP><COL style="WIDTH: 180pt; mso-width-source: userset...
  13. A

    Outlook text list to columns

    Hello all! Thanks in advance for your time :) I have been trying to take a very large excel list such as: Brown, Angela; Lex, Amy; Jones, Cheryl; Loria, Patty; ......... and move it to columns in excel. I've tried text to columns, and I can get it split up correctly, then I try to copy and...
  14. melewie

    Text to Columns Macro

    Hi All,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I’m having a problem building a error trap in a "simple" macro. I want the macro to bring up a message box if there is no column selected. But having trouble making this happen<o:p></o:p>...
  15. M

    Text to Columns: Losing Data?

    Hello - One of my clients sent me a file of addresses that seems to have been pulled from some sort of database and the formatting on the addresses is a little sloppy. Every line of the address is in one cell and there are some extra characters which excel isn't reading quite right (these...
  16. G

    Split Data in Two Column

    I have Employee Names such as: John Violet Mary jr Dsouza B n Chandra I want to split it into two columns, at all places where there is a capital Character. Such as John Violet Mary jr Dsouza B n Chandra --------------------- Regards, ~Vani~
  17. T

    How to separate a line of alternating Text/Numbers into Columns

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

    Convert Text to Table?

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

    Parsing and Line Breaks

    Hi all, I've been using the forums for several days to get answers to my questions but finally came across a dead end. Please help! I'm working with a dataset where there is a whole bunch of text in one cell that I need to parse. There are two delimiters: "~" and ";". Furthermore, there are...
  20. R

    Sort of like opposite of concatenate

    My data looks like this: Cell A9 - Backplate 1-2 weeks 14 Cell A10 - Carbon Wall Mounts 1-2 weeks 14 Cell A11 - AP Mount 1-2 weeks 14 Cell A12 - AP Power Pack Mount 1-2 weeks 14 I want to do some kind of text to columns or formula or something that will leave me with: Cell A9...

Some videos you may like

This Week's Hot Topics