text to columns

  1. J

    Deliminating and Re-Combining cells

    I'm not quite sure what I'm even asking, but I'll throw it out there anyway. I have a spreadsheet that is exported from a piece of software. It has a column that describes the related work, labeled Tags. The tags column has each tag in it, separated by commas. I need to be able to see how many...
  2. G

    Use a formula to set delimiter in text to columns?

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

    Separate numbers from a phrase in a cell

    How do you separate numbers from a phrase in a cell given the scenarios below? All I need are the word/ phrases. Here are sample contents of the cells: the quick 89 quick 143 the quick brown 7 brown fox 23 As one can see, all the numbers are at the right end but the digits vary while the...
  4. G

    Trying to have Text to Columns (might be a little different from just using function)

    Hi guys, I have a list of elements on my excel sheet. The column that I need to do 'text to column' looks something like this MDL1-Men's Wear MODL1-Women's Wear MODEL2-Fragrance MODEL3-Maagzines ... I just want to split the contenet before the hyphen and after that into two seperate columns...
  5. Johnny Thunder

    Convert Text To Columns Shortcut - Excel 2010

    I was wondering if there is a shortcut to run "Convert text to Columns" Using ALT+A+E+W+N gets you to the data preview that has a ruler, the part I need the shortcut for would be to get the ruler to the 10 mark without using the mouse? Any help would be appreciated. Thanks
  6. M

    I need a vba code

    I have one item number with multiple suppliers and their price for that item in one row. I need to reformat the data. Instead of the all prices being in one row I need to have each price in its own row Now I have: A1---------G1------H1-------I1-------J1------K1-------L1--------M1 OEM#...
  7. M

    Txt to Columns w/ a "space", "5 random numbers", then a "space" or "dash"

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

    VBA - Text to columns with variable array

    Hello MrExcel! I have the following code in a macro: Range("BB9").TextToColumns Destination:=Range("BH1"), DataType:=xlDelimited, _ TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=False, _ Semicolon:=False, Comma:=True, Space:=False, Other:=False, FieldInfo _...
  9. N

    VBA: Text To Columns then Add Formula

    Hi All, I'm quite new to VBA and am building a messy code to help me with some large text files. I have the first part of my code to import the text file into as many sheets as necessary, but I'm coming unstuck on the second part. I have a code to run a Text to Columns (TTC) function (comma...
  10. R

    Reformat a list in a single column into multiple rows.

    What I want to do is to take a report (see below) that is generated by our system and convert it into a list that can be referenced by other worksheets and macros. The report shows a list of orders (PO Number) in a shipment but rather than having each order on its individual row, each shipment...
  11. V

    Need to seperate data of different length in separate columns

    hi, Please help me seperate data after every space, in separate columns. I did see similar queries answered by others but it would be great if you could help me sort the data. For eg, the data mentioned below needs to be separated into separate columns (after every SPACE) <TABLE...
  12. T

    Help with Text to Columns in VBA

    I have a macro that imports data from the web and puts it into four different columns- A, H, O, and V. I'd like to space the web data out over 7 columns (so from A through G for the first column of data, H through N for the second column of data, and so on). When I tried using this piece of code...
  13. S

    Text to Columns, Delimit by Paragraph

    What I have: I have a .csv file that has a column that contains 4 paragraphs of text within each cell. When "wrap text" is selected, an individual cell appears neatly formatted. I have roughly 300 rows of these paragraphs (300R x1C) What I am trying to do: Remove paragraphs 2 & 4 while...
  14. D

    Text to Columns - Excel 2003

    I am typically savy with Excel, but am a bit stumped, and I am hoping someone on this forum can lend some insights and guidance. I am using the Text to Columns feature to separate values into separate columns - each value is delimited by a comma. Company Name, Address 1, Address 2, City...
  15. Jasa P

    VBA code for Text to Columns

    Hi, I'm looking for VBA code that can save the function of Text to Columns. So, if I open a workbook and paste the combination below, I don't need to separate them manually using Text to Column. This combination will be separate in few columns automatically after I pasted them in workbook...
  16. L

    Text To Columns VBA Date problem

    Hello, I'm importing some data from a worksheet using Text to Columns command, when I do it manually it works ok but when I run it on VBA excel converts the data in text format. I've already tried putting xlDMYformat in the array but it still doesn't work. The code is: Workbooks.OpenText...
  17. W

    Find and Load a CSV

    Greetings Mr. Excel, I'm working on a macro that will open a prompt window to select any csv file, then run it through a text to columns, but having issues after finding the file. Here's what I have so far. Also, I was wondering if there was a way for me to get the file name into a cell after...
  18. I

    Separation Anxiety!

    I have a WB where column A contains stocks and stock symbols. The stock symbols represent the last 1-4 letters in each cell. Because each stock name (and symbol) is of different length and may or may not have multiple spaces, the traditional means of "reverse contatenation" aren't helping (e.g...
  19. T

    Text to Columns Excel 2007

    Dear All, I have a problem with Text to Columns in Excel 2007. Could you please explain me, how does it work (I mean what's inside)? The problem is: Sometimes Vlookup function does not work but when I use TtC with the values defined as "Table Array" it starts to work! My steps: 1) Highlight the...
  20. Weaver

    Dates with "." for a delimiter

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

Some videos you may like

This Week's Hot Topics