text to columns

  1. 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)...
  2. B

    Convert text to column and transpose

    Hello, Excel Gurus! I have some data like below in the first image and I want to change it to like the second image by using a macro. In the real table there are a lot more columns and rows, but columns who should be made "text to column" and "transposed" are two: Product Color...
  3. M

    Text to Columns Time Issue in Macro

    I have data that is formatted like so... <tbody> calldate 12/12/2015 18:52 12/12/2015 16:50 12/12/2015 16:17 12/12/2015 14:00 12/12/2015 13:44 12/12/2015 13:35 12/12/2015 13:11 </tbody> I'm running a macro, and one part of that macro is to separate the date/time column into...
  4. J

    How to stop a value convert to date after using Text to Columns feature in Excel 2010?

    let's say I have a cell A1 contain 2 values input as (1,3/4), I want to separate the values into other columns like B1 (1) and C1 (3/4) using the Text to Columns delimited feature. However, it keeps showing me as C1(4-March) even though I formatted original cell to text format already...
  5. M

    An annoying bug (?) when using text to columns

    Hi, First time on this forum so looking forward to improving my Excel skills here. I'm not an Excel newbie but I'm not an expert either. I've been building a tabular dataset using results posted on ResultsDB detailing English Premiership football results going back to season 2000-01. The...
  6. T

    Opening CSV files with automatic 'text to columns'

    Hello, I have a problem when opening CSV files and the data is all jumbled. I would like to open the file and have the data sorted like 'text to columns' but without doing it manually. I did create a macro to remove the delimiter but I need to simplify the process even more. Any help is...
  7. M

    Seperating info from 1 cell within a form to multiple cells within a query

    Hello, I'm trying to do what is typically done within excel using the "Convert Text to Columns" wizard (Delimited) and a "Paste Special - Transpose" function within Access. For example, within the form in access, I have several dates listed, seperated by a comma (1/3/16, 1/5/16, 1/6/16...
  8. P

    Split unformatted addresses into separate columns

    Hello Excel experts, This is my first post here. I need your help in solving an issue with separating out addresses into address, city, state and pin code. This is how my data looks now. <tbody> <colgroup><col></colgroup><tbody> 503, LEVEL 5 , BLOCK A KELANA CENTRE POINT 3, JALAN SS 7/19...
  9. A

    Text to Columns for a Large String

    Hello, I have a large number of addresses which have been put into one column. I need to split up the addresses in order to put together a mail merge file. The problem is that there are too many individual words for the normal text to columns function to work eg one address might be c/o Mrs M...
  10. A

    DB Problem - text to rows adding datas on new rows

    Excel version: 2013 Problem: Hi everyone! I'm an economics student researching for my master thesis on 3D printing, I was trying to create a database of 3D printers with various informations (Company, Model, Materials etc.) where 1 material coincided to one row. My problem started when I...
  11. N

    How to split a cell at the cursor?

    I have a survey with a significant amount of open ended questions. It order to code the survey I need to split each section of each open ended response into one cell. For example, the single cell: "Service was slow and I hated the food" would become two cells, "Service was slow" & "and I...
  12. L

    Inverse of Merge, or text to ROWS.

    Hello all, I have a question I have not seen answered yet, and I have no idea how to accomplish this. I have some data which shares some common elements, but has unique values. Some cells have multiple items separated by a linefeed (Alt+Return) as in the description column. For example I would...
  13. D

    Text to columns problem - data disappearing

    Hi there, I am trying to separate 160 rows of data into columns. Each piece of data is separated by a | currently, however between clicking next after step 1 and step 2 the majority of the data disappears and when I click finish only 2 pieces of data from the cell have separated and the rest...
  14. J

    Text to Columns in Visual Basic with English Dates

    Hi All! I'm new to VBA so apologies if this is more straightforward than it seems. I have a spreadsheet which is used to automate some report formatting and create graphs for an end user. The end user exports the required reports from our database, pastes them into my workbook and my macro then...
  15. D

    Text to Columns - Can't change destination fields to text

    When separating telephone numbers to the appropriate format, I change the destination cells in the spreadsheet to 'text', and also change the destination fields to 'text' in the 'text to columns' wizard. The separated numbers, however, still drop leading zeros. How can I retain the leading zeros...
  16. A

    VBA: Multiplying Values Separted by Comma

    Hi Everyone, I've run into a little roadblock, and any help would be greatly appreciated! Right now, I have a few hundred cells, and within each cell, there are different number of values separated by commas. Each cell to the right of the cell has different values but the same exact number of...
  17. A

    Maintain final zeros in text to columns

    HI, MS Excel 2010 I have the text strings below (900+ in total). The final numerical column represents the version number where in 3.1 is "three-point-one" and 3.10 is "three-point-ten". R^11-111111^Some Document^1.40 (one-point-forty) <TBODY> R^22-222222^Another Document^1.4...
  18. E

    Text to Columns - Old question; New solution?

    Excel 2010 saves the Text to Columns parameters until Excel is closed. For example, if one checks the box near Comma, the next import or selection will automatically be delimited by comma, whether one wants it or not. Can this behavior be turned off? Most of the posts on this subject are quite...
  19. D

    Text to columns for a large amount of data

    Hi there, Thank you in advance for your assistance. I'm a bit of an Excel novice. I've been given the task of splitting up a large amount of delimiter-separated values that need separating. Unfortunately, the list was provided to me in a Word document and all the data is lumped together (all...
  20. L

    MS Excel 2010 - Name- Address-City, State and Zip in 3 separate rows - want to change to columns

    Reaching out for help after many attempts. I dont think text to columns will work in this situation, but not sure A2 = Name A3 = Street Adress A4 = City, State and Zip A5 =Then a blank row A6 = Name A7 = Street Adress A8 = City, State and Zip And so on.. I need to make labels and this...

Some videos you may like

This Week's Hot Topics

Top