text to columns

  1. L

    Text to columns, multiple spaces and columns

    Hello, I need to extract what is in B2 to reorganize only information to the right and one space ahead of each "X". Example below. Any help is much appreciated! Sample data: AB1Order#Item2123452X ABC 3X 123 1X Apple 6X Banana 9X Dog Desired output: AB1Order...
  2. littlefish

    Convert Text to Columns (Cells Include Line Breaks)

    I have a single column of several hundred rows of data that I would like to use the "convert text to columns" wizard, however, in addition to typical delimiters (i.e. "," and ";") these cells contain line breaks. When I run the wizard, the result is a single column of data to the point of the...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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!
  18. 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...
  19. 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...
  20. 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...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back