Stack Overflow
Stack Overflow

Questions tagged [text-to-column]

72 questions
0
votes
1 answer

Excel VBA Text-to-column with xltextformat

I am using text-to-column function to split a string which is taken from a input box. How do I define the text format for the split text? At the moment, the text "3101/09/1" will be automatically changed to a Date format "01/09/3101". I have tried…
Jimmy.L
  • 25
  • 5
0
votes
0 answers

Text to Column tool is interrupting my conditional formatting

I have a range of data that is pulled via a query, and then I use a data range comparison to highlight data. For instance, if I pull my data in sheet 'A', and input my own data in sheet 'B', I am checking to see what data on sheet 'A' is also on…
ColonelMustard
  • 3
  • 2
0
votes
0 answers

Need help using Text to Columns & Fieldinfo to parse columns with VBA in Excel

Per comments below, I'm editing my original posted question to more accurately reflect my problem. This is for my job. In my work program, I download my data table to a csv file and it automatically opens the data in Notepad. I don't save the file…
Macca
  • 1
  • 4
0
votes
1 answer

VBA TextToColumns - Date format

I have a problem with macro TextToColumns: I have two date formats, one with 01:00 at the end and the other with 03:00 at the end, for example: 14/10/2019 03:00 08/06/2019 01:00 When I run macro: Worksheet.Columns("A:A").TextToColumns…
Hanna
  • 23
  • 1
  • 3
0
votes
2 answers

How would I write a VBA code which converts columns of a table from text to dates whenever the worksheet is changed?

I'm trying to automate an analysis of data for a client. Their system exports the data in text format, including the dates. In order for the dates to be usable in my analysis, they need to be converted from text to dates. Manually, the only way I…
devinamber
  • 1
  • 1
0
votes
1 answer

How to format date when converting text to columns?

I'm trying to convert a range of data, from text to columns, with VBA. When I apply the code some cells with date don't convert as date. If then you enter the cell and press "enter" it converts to date format. Selection.TextToColumns _ …
Marcos R
  • 1
  • 3
0
votes
1 answer

Excel Vba split multiple cells into columns

My file has multiple lines (72000+) written like this: UNIX timestamp;User id;In/Out This homework is about a parking lot. My problem is how do I split all col A into 3 other cols (like B, C and D). I found the split function but I not…
xPudimx
  • 11
  • 5
0
votes
0 answers

Converting Text Format Data in Columns using Excel VBA

I have some reports extracted from Oracle in text file. I have pasted the data in excel. Now my whole data is in Column A and I am trying to convert the data in tabular form. The delimiter in one cell in the text file is --------- -------------…
Azma
  • 1
  • 1
0
votes
3 answers

excel text to column delimiter starting from end of the row

I have strings in a column that look like this /name/safsdf/231232/asesa/filename.mp4 /ds2/sasdsfsdf/2fd32/a234sa/filenameb.mp4 ... ... so text to column works great i can easily make a column that has just the filenames without the folders. My…
chowpay
  • 1,515
  • 6
  • 22
  • 44
0
votes
2 answers

How to use two slashes in 'text to column' in excel?

Why doesn't Excel allow us to use two slashes in the Data > Text to Columns > Delimited > Other section? I have several rows which have similar data. Each row also has two contiguous slashes. I want to separate the column which begins from the two…
zeewagon
  • 1,835
  • 4
  • 18
  • 22
0
votes
0 answers

Auto “Cancel” Excel alert

My issue: I have a Macro, which sets my worksheet up to convert text into columns automatically, whenever I activate the sheet... However when I have pasted the data, and move back and forth between the sheets, it will say “There’s already data…
Patrick S
  • 325
  • 2
  • 12
0
votes
1 answer

TextToColumns ruining data that is already split into cells

My issue: I have a workbook, and within it, I have three different sheets. Sheet 1 is some data from a PDF-file, where I want to use my TextToColumns. Sheet 2 contains data from our financial database, whereas it is already split into cells. Sheet 3…
Patrick S
  • 325
  • 2
  • 12
0
votes
2 answers

Excel VBA merging cell values

I have a macro, where I convert text into columns, so that I can use the data from my PDF file. Althought it works really well, I would like to know if it could be developed. My data should look something like this: Invoice 10-12-2017 USD …
Patrick S
  • 325
  • 2
  • 12
0
votes
1 answer

VBA: Text to column for a specific columns

I'm trying to do a macro that can find a column by the name of the header , then to select entire column and run the "text to column" command. I've recorded the macro based on the current position of the columns: Sub TTC() …
George OST
  • 51
  • 2
  • 10
0
votes
1 answer

Error code 'Subscript out of range' when running 'Text to column' macro

I am trying to convert a series of dates from text to 'Date' format, that are in column B on the 'Master' sheet. I created a macro but I want to run it from any Worksheet rather than being on the Master worksheet. However, the error code 'Subscript…
Joon10
  • 1
1 2 3
4
5