texttocolumns

  1. B

    Text to columns to a different sheet using VBA.!?

    Hi people, How do I split text from a range in a column (maybe using text to column, separator "x") to a different worksheet and rearrange. To make you understand better here is a image of the source data(Sheet1) My expected output is something like(Sheet2): I've done Sub customSplit()...
  2. R

    Range Data formating texttocolumns

    Hello, I am trying to run texttocolumns using VBA Range("O4:O1500").Selection.TextToColumns _ Destination:=Range("O78"), _ DataType:=False, _ ConsecutiveDelimiter:=False, _ Semicolon:=False, _ Comma:=False, _ Space:=False, _ Other:=False...
  3. J

    Dynamic Text to Columns, Loop through columns

    Hi, I have a series of data that, essentially, only needs to be "refreshed" before that data can be run through a new macro. IE, a macro go through each cell and {F2}+{ENTER}. But that takes too long, so i've written a macro that will go through each column and do a TextToColumn, simply...
  4. E

    Extract numbers from text and number cell

    Hello, I am looking for a way to extract a number from a string or text, symbols and numbers. For example I have the following in A1 {Low:”100″,medium:”300″,high:”5000″} I would like to take the low number in A2, the medium number in A3 and the high number in A4. I have tried a series of...
  5. E

    Text to column formula

    Hello, I am looking for a way to extract a number from a string or text, symbols and numbers. For example I have the following in A1 {Low:”100″,medium:”300″,high:”5000″} I would like to take the low number in A2, the medium number in A3 and the high number in A4. I have tried a series of...
  6. K

    TextToColumns convert values to dates (VBA)

    I am using VBA to open a csv file and split it to columns by using commando TextToColumns. After running the macro the hext has been split to columns but some values have been changed to dates, for example values starting with 07-5... When I do the same thing in Excel without using VBA those...
  7. M

    Delete text after delimiter using text to columns

    Hi, quite often I get spreadsheets containing product numbers - however, they often have a "#" as delimiter followed by a three letter option code. The data can come in a any column and vary from 5 to 1000 rows. So, I wan to make a permanent tool where I can select the column with the specific...
  8. J

    TextToColumns different in macro than outside of macro

    Hello everyone :) I'm quite new to Excel macros but I've been introduced to a piece of work and I must say I'm completely stumped. A bit of background first, not quite relevant to the problem but let's you know where I stand. I've re-written an application that generates excel reports from a...
  9. S

    Easier way converting text to columns using VBA. I'm a VBA beginner.

    Hello everyone, I'm running this code to convert a range of columns (from personal.xlsb). The reason for using this code is that it only converts numbers to text and doesn't change for example dates. It works but there has to be another way to let the code loop or run until the last filled...
  10. H

    Can you delimit by date?

    I have a large string of text that was a former "Note" Field. I have various dates within. Is there a way to delimit that string of text similar to how the Text to Columns feature works? But instead of by , "comma" you can use a date? Thanks guys Here is a sample of what I have: 01/01/2016...
  11. E

    VBA TextToColumns from hidden workbook

    Hi all, I have a hidden workbook called PERSONAL.XLSB located in C:\Users\xxxxxx\AppData\Roaming\Microsoft\Excel\XLSTART\PERSONAL.XLSB, that way I can store macros in that workbook that will then be available for all other workbooks I open. I work alot with an ERP system where the export comes...
  12. R

    Multiple character delimiter for text to column function

    Hello, I have a column of data with the fields separated by differing combinations of commas, semi-colons, multiple spaces and tabs. The only thing the separations have in common is that they all incorporate more than one space. I would like to use the text to columns feature to separate the...
  13. W

    Convert Column of comma delimited Keyword/phrases to a range of unique values

    I have a column in a Table with keywords. Here's an example: <colgroup><col></colgroup><tbody> Location,performance errors,ip address,impact ip address, identification, transaction Performance, identification historic, performance, UI performance, consolidation, identification...
  14. R

    Avoid converting to date when using TextToColumns

    I have a problem, beacause I import data from text files and some tables come with codes like SEP4, which is converted automatically to date (september 4th). On Microsoft help pages, one of their suggestions is to put empty space. But it seems to work only when I enter data manualy in a cell...
  15. D

    Formatting a Named Range

    Afternoon All, I ahvea tricky one, i have data that i am sorting and then copying in to a field that is used as a named range. Im running the code below in order to change the data from TEXT ot numbers. I know that the data is AlphaNumeric but i would 3 digit numbers for Example "10" would be...

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
Top