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