texttocolumn

  1. A

    Dates show DMY in cell, but MDY in formula bar - won't sort or convert

    Hello - I'm using O365 in the US but have system time on my PC set for Australia (in case this matters…) WorkSheet #1 I have received two excel worksheets, one has dates formatted in DMY, and if I switch the formatting of any of those cells to General, I see that the resulting number (in...
  2. K

    Need help on converting a batch of txt to excel using VBA

    I was trying to batch convert text files to excel using VBA and found this code in this web. This is how my text looks like: ABC|123|DEF ZZZ|233|YTU HHH|789|HJK <code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch...
  3. T

    Text to columns - changing data strings

    I'm trying to break a credit card statement from PDF to excel so the data can be useful. However the character strings are constantly changing based on vendor, location and the value of the transaction. Below is a sub-set sample of data. Date is easy to extract - LEFT(A1,5). But how do I...
  4. 9tanstaafl9

    Can you restrict the used columns in VBA TextToColumns so that it won't overwrite other data?

    I frequently have to clean up phone numbers for data import. I got everything to work perfectly, EXCEPT for the rare instances where there might be more than one delimiter between a phone number and an extension. So these work fine: 444-444-4444 ext: 2345 333-1111 #2224456 cindy But this...
  5. M

    Formatting data and using macro for text to columns feature

    Hi All, I have a sample xl file having data as shown below: ____________________________________________________________ | Column A | Column B| Column C | | H1 H2 H3 H4 H5 H6 | |...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top