text to column

  1. D

    Convert text to number for currency

    I need to write a macro for converting text to number. I have tried recording when I do text to columns but when I tried to run the macro under the same conditions as when it was recorded then it doesn't wok and the numbers stay as text. What do I need to do to make the text convert to a number?
  2. T

    Text to Columns selection and cell formatting

    Hi all, Currently I have the code below, which converts text to columns. I paste the text (with multiple rows) in cell A1 and run the macro. Sub TextToColumns() Columns("A:A").Select Selection.TextToColumns Destination:=Range("A1"), DataType:=xlFixedWidth, _...
  3. T

    ToggleButton hide columns under conditions

    Hi all, I have the code below now, but when I manually hide a column (for example column C) and use the toggle button twice, column C is visible again and I want it to stay hidden. Is there a possibility to do that? Private Sub ToggleButton1_Click() Dim xAddress As String xAddress = "A:Z" If...
  4. S

    Find first instance of text in range of cells

    I have a range. The cells contain a string in them. The string consists of a date (mm/dd/yyyy) and either 1 of two words: Yes or No. Example: <tbody> 07/22/2015 - No </tbody> They are in a single cell, in a single column. Regardless of I need to extract the date preceding the " - " from...
  5. T

    How to remove extra characters from a data set when transferring data via text to column

    Here's the situation. we are moving to a new CRM (or to a single REAL CRM if you want to be honest) and we need each phone number in a new column with out the jargon (random notes) behind it. The phone number are in one column now, separated by an alt return. The phone number look like the...
  6. P

    Splitting out text in cell A1

    Hi I have a series of sentences with bullet points all in cell A1 of a workbook. I would like to split out so each bullet point has its own cell in column A. The second bullet point would go into cell A2 and so on. Is this possible? Appreciate any help.
  7. D

    dealing with macros/mid-find and text to column

    So I have this problem when importing a csv file, one cell has information that needs to be split into columns or repeated with the same tablet id. I have tried several combinations but everything takes time and it is not clean and it doesnt solve the problem, any ideas data is below and the two...
  8. A

    What is the Basic Formula to Split Cells Using "Text to Columns" Option?

    Need to figure out the formula to split cells using "Text to Columns", using the "Delimited" option for Original Data Type,the "Comma" option for Delimiters, and the "General" option for Column Data Format. Or find faster way to accomplish task without clicking through it. Thanks! :):):)
  9. G

    Column format for VBA text to column

    I am using VBA to import some data from TXT files to excel, depending on the name of txt file it is either fixed width or comma delimited. For both examples I need to be set the format of certain columns to text rather than general that it defaults to. If it helps here is the relevant bit of...
  10. H

    Using text to columns to separate city/state

    I have a set of data that looks like this: Milwaukee WI New Berlin WI Franklin WI New York City NY How can I separate these into 2 columns for city and state without using either a right/trim formula combination or a space delimited/concatenate combination?
  11. J

    How do I stop auto Text To Column

    EXCEL 2016 I downloaded a file as a .csv from a work database. I'm opening the file in excel and it is automatically splitting the first column (last name,first name) into 2 columns. I'm assuming it's because it thinks it's helping me because it sees the comma. I do not want this to happen. How...
  12. A

    Unstable/Crashing with Excel 2016 for Mac

    Folks, I've researched till I'm blue in the face...literally. This is my last hope so I thought I would stop here. I've snooped around in these forums for awhile but never really posted. Thought maybe you all could help a brother out. My excel seems fairly unstable, it crashes almost daily...
  13. P

    Import text file to excel that contains about a million rows

    Hi, I have a text file that contains about a million rows with space delimited. Out of these million records, the data that suits my criteria would be only around 3 thousand. The criteria is the "Date" column as in the below example how my text file looks. Model Invoice Date Description...
  14. R

    "Text to columns" for unorganized notepad

    Hi, I have a notepad which has around 20 entries. I have to import these entries and convert it into columns. This would have been easy, if present in a single row. but these are broken rows and are present in 4 rows. Thus, excel converts these entries into 4 different rows while...
  15. L

    Extract all text from a string with numbers and characters

    Hello All, I have a column of seat (arena) data. The data contains section numbers and rows. I want to extract the section numbers into 1 column and the row (letters) into another column. Here's an example of my data set: <colgroup><col></colgroup><tbody> 104 BB 103 & 105 BB 104 CC 103...
  16. Ombir

    Text to columns changing values. Why ?

    Hi Folks, I am trying to convert values in one column by using Text to column. Strange thing that is happening is that last digits of value are being converted into some another value.Sample is given below: <b></b><table cellpadding="2.5px" rules="all" style=";background-color...
  17. 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...
  18. W

    Need a more advanced Text to Columns setup, please

    So I have to create a macro for a project that's due no later than 2 days from now. The first part consists of splitting the contents, which Text to Columns normally works well for but not in this case since it is a large data set and doing touch-ups afterwards is a long and tedious process. I'd...
  19. 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...
  20. W

    Dynamic Text To Column

    I'm trying to create a dynamic text to column but i have no idea how to do this. Basically I have a cell that will contain quantity and sizes of apparel and may look something like this: 20/s 13/M 14/L I can do a text to column that will pull this information out into individual cells to...

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