text to columns

  1. MrExcel

    Splitting a CSV file into 205 individual one-character columns

    I was doing a seminar recently and an auditor had a need to split an ACH file into 205 columns, with each column being one character wide. Her current process: Use Data, Text to Columns, Fixed Width, and then click 204 times in the Data Preview Window of Step 2 of the Wizard. One idea from...
  2. C

    What is the mac equivalent of ctrl+j in the text to columns wizard?

    I'm writing a macro and one of the steps involves splitting multiple rows in one cell into their own separate rows. What is the equivalent of hitting ctrl+J in the text to columns wizard? I've already tried ⌘+J, ^+J, and ⌥+J, but those aren't working. If anyone knows of a chart that lists the...
  3. N

    Tab Text Delimiting not working

    Hello, I have a workbook where the data appears to be tab delimited but isn't working in Text-to-Columns. I'm looking for help making text to columns work or other manual "left" "right" "mid" formulas to get it done. Workbook sample below where the data in Row 2 corresponds to the following...
  4. S

    Extract Numbers from Formula to Columns

    What formula will extract numbers from a formula using any operator as the delimiter? For example: <tbody> Invoice Amount Product 1 Product 2 Product 3 =4384+89463+9876 4384 89463 9876 </tbody> The invoice amount has a formula that is auto populated from our system and I want to...
  5. F

    Text to Columns Formula

    I'm hoping someone can help me with splitting a column of data into six separate columns. I've tried using various functions with no luck, as the numbers can be different lengths, although each are separated by a forward slash. The "Text to Columns" feature isn't really an option as I'm hoping a...
  6. E

    Delimiter result not the formula

    I have a string that was exported from another program. It has quotation marks around it so I cannot do a text to columns on it Below is one cell. "PROBLEM: LOAD ERROR, WILL NOT CHARGE SOLUTION: REPLACE MAINBOARD, BARCODE AND PIN FIX, REPLACE IO LEVEL 2: BILL COMPANY, 201080354, 30160045 REPAIR...
  7. M

    Advanced excel: column breaks every n characters (text to columns, fixed width)

    Hello dear MrExcel community, I have stumbled upon a problem that for me is really hard to resolve. Problem is that I have a file in .txt format, after I open it with excel I need to get columns with it with Text To Columns option. The thing is, fixed width needs to be selected and then you...
  8. bs0d

    Txt To Columns Correction

    Sometimes I receive data that has a text to columns bust. Assume a list of accounts are in column A, and column B has numbers. In some cases with very large numbers, the first digit of the value for column B will be the last character in column A. I could detect accounts where this happened...
  9. R

    Text to columns format issue with fractions

    I am using text to columns to modify the following data: <colgroup><col></colgroup><tbody> 1-1/8 61X145 PB 1-1/8 61X121 PB 3/4 49X97 PB 3/4 49X97 PB 3/4 49X97 PB 5/8 49X97 PB 5/8 49X97 PB 1 49X97 PB 1 49X97 PB 1/2 49X97 PB 1/2 49X97 PB I want to see this...
  10. F

    Data manipulation to remove undesired character strings

    Hello Mr. Excel experts! I'm in need of help to manipulate a data report that populates the entire information into one cell ("Text to columns" does not work unless there's some amazing trick I don't know how to use). This is a credit card financial statement data. Below is a small...
  11. H

    Macro Help

    So i have a column called BA - i want to do Text to Columns to column BC - but every time i try to record a macro - it 'records' but when i go to execute it in a workbook i get an error. i'm curious about a couple of things. A) how do i record a macro that will be available to any workbook i...
  12. G

    Text to Columns to Rows Macro

    Hello, I am looking for some help or to repurpose a simple macro to do two things. I have a table of data that consists of a few columns of consistent data (ex. vendor names and vendor numbers) and then one column with cells full of comma delimited invoice numbers. What I would like to do is...
  13. A

    text filters vs date filters

    I have two Excel workbooks, one being a clone of the other, and each having multiple columns in which dates are populated by formulas. In my original workbook, I am able to filter each column using date filters (next month, this month, etc.), but in the second workbook, the only filter option is...
  14. L

    Convert text to columns multiple sheets

    Hello, I'm trying to create a macro in VBA which should convert all cells from B2 and downwards into mutiple columns. I got 8 sheets called D1, D2, ..., D8 - which all need to be affected by this macro. The character to seperate will be a comma. The macro will seperate dates from each other...
  15. C

    Text To Columns Command in Excel 2010 with Alt+Enter

    Good morning I have a column containing: Street Address (Alt+Enter for line break) City State Zip (Alt+Enter for line break) Country I am attempting to use Text to Columns to break this entry to three columns, but cannot figure out how to use Alt+Enter as the delimiter. Thanks in advance!
  16. A

    Advance Text to Columns needed

    Hi Everyone, Need Some help. I have sheet with Title + Company in single excel cell. There are about 590 Rows. Examples Owner at SPP Company CEO and President at Zisoo Co INC Principal of ILT PVT Limited. Founder and Managing Director - IPKA Tel INC As you can see I cannot use Excel Text to...
  17. E

    How can I perform a "Text to columns and Transpose" for a variable # of columns?

    Hello, thanks in advance for your help. I have data exported from Outlook in 3 columns: To (address), To (display), and To (address type) I want to do a text-to-columns and transpose such that each address (separated by a ";" in all three columns) gets it's own row. Easy enough to do if all...
  18. J

    How to transfer data from one cell to columns when there is no delimiter?

    Hey there, I got a major problem with my dataset (500+ rows) and since I am not an Excel Pro and couldn't find answers on the internet I am posting my first ever question online: Okay here is the issue, I want to put every number of this column in another cell, like I did it for the first two...
  19. F

    Text to columns with multiple rows of text in a cell

    Hi, I'm trying to get the names in row C of the screenshot into two different columns, ideally, I'd like to have the content in every cell from row C listed the way they contend from C1 is now listed in cells D1-4 and E1-4. Let me know if you need more information. Screenshot URL: Image -...
  20. A

    Text to columns vba

    Thank you in advance for anyone willing to solve this problem. I'm in need of a solution for an excel file in which each cell within two columns labeled, "Primary Diagnosis" and "Secondary Diagnosis" of a 100 column worksheet contain multiple ICD-9 or ICD-10(Industry Standard Diagnosis Codes)...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top