Stack Overflow
Stack Overflow

Questions tagged [text-to-column]

72 questions
1
vote
3 answers

How to separate words from single column

I am trying to read data from a text file using excel/VBA. However when i import the file all the words are in the same column. The text is generated from PDF while preserving the table layout. So the words are space delimited, but the spacing is…
isomericharsh
  • 83
  • 7
1
vote
1 answer

text to column in excel using VBA

I will really appreciate your help if anyone can advise me how to separate the given data shown in the image into separate columns. I have tried using fixed length but you can separate the first 2 to 3 numbers correctly into the columns but the 4th,…
Fahad
  • 21
  • 2
1
vote
1 answer

Excel text to columns formatting to date issue

Good morning, I have a macro that imports all text files from a directory into the workbook. This has been working very well and has not had any formatting or related issues. I have encountered text files that seem to autoformat and am having…
Excel Help
  • 13
  • 4
1
vote
1 answer

How to refresh settings for text-to-columns function vba

I have a file with a few functions. One of them divides text to columns in selected range: Sub txt2clmns() Dim rng As Range Set rng = [i5] Set rng = Range(rng, Cells(Rows.Count, rng.Column).End(xlUp)) rng.TextToColumns _ …
BangBoy
  • 45
  • 6
1
vote
4 answers

ERROR Date and Time Text to Columns Macro Excel VBA

I am having trouble coding a macro to separate a cell with date and time information in to columns with TexttoColumns formula. This is the information I have in the column. Beginning Date 1900-01-01 (00:00) 2008-09-25 (12:46) I want all the column…
Antonio
  • 11
  • 1
1
vote
1 answer

Text to column for loop

So basically I have multiple columns of text that I want to change to numbers. Now the issue i face is ive got the code but i dont understand how to run a loop on it to choose the next third column. This is my code: Sub…
Isra Shaikh
  • 151
  • 2
  • 4
  • 12
0
votes
1 answer

Fastest way to parse a Word document containing Transcript text into Excel columns

I have multiple word document files, each containing transcript text like below (paragraph marks not shown): Some Title1 ' <--- Some title ending with paragraph mark (Apr 3, 2023 - 9:00am) ' <--- Date - time ending with paragraph…
sifar
  • 1,086
  • 1
  • 17
  • 43
0
votes
2 answers

vba macro manipulating text to column function in excel and change priority of info with same delimeter

I am overall quite new to excel so any help is greatly appreciated, concerning my problem. I download data from a vendor and the identifying data,(the first column), has an individual's name and their participant number in the same column separated…
Matt B
  • 3
  • 1
0
votes
1 answer

Excel Formula To Replicate Text To Column Functionality

I would like a formula in excel that does what Text To Columns does. For example the following string in A1 " text with a comma, stays in one column",," keep starting blank text",1,2,3,"123" Would be split into multiple cells like this...
Andy Robertson
  • 171
  • 2
  • 6
0
votes
1 answer

Google Sheets Split Text to Column by First Text character

I have 1 column of data that I want to split to units & product name. In the desired format its not really necessary for headers, so if we need to omit them that's fine. I normally have around 200+ rows of data that I want to split. Currently I do…
Genny
  • 133
  • 1
  • 6
0
votes
1 answer

Text to columns - issue with commas

I am trying to seperate my columns with vba. This is how my data looks: first row: Time,[CB:01:4A:7D:06:2D] Thermometer_0,[E5:39:8E:7F:E4:11] Thermometer_0,[F1:89:F8:3A:EA:63] Thermometer_0,[F7:C6:4A:56:E4:23] Thermometer_0 second row: 11/23/2021…
Eva
  • 9
  • 6
0
votes
0 answers

My excel dates are not working, how do I solve?

I pasted data into my Excel and the dates are not working, they work on some rows but not on others as seen from embedded screenshot. I'm conducting av event study based of data i've sourced from a terminal and pasted it into my excel from an US…
32kode
  • 3
  • 2
0
votes
2 answers

Excel text to rows using formula

I have a concat formula returning me a comma separated list of names in a cell =concat(A2:A10 & " ,") returning [john, jack, jill] in the cell Is there a way to add to this formula to expand to john jack jill in a column like that above?
maxokream
  • 43
  • 5
0
votes
2 answers

Change Text to Date with VBA TextToColumns

Edit: VBA code now is working. Was just and .currentregion that messed it up for me I have an issue, that is hopefully just some silly mistake from myside. I have a dataset that I get at least once a day with the dates not recognised as date, but as…
Akire
  • 169
  • 3
  • 13
0
votes
1 answer

How do I use text-to-columns to keep only the final column in Excel?

I'm in Excel and I have a long list of folder directories like you see below. I want to use the forward slash delimiter to only keep only the file name in the directory. The problem is that each directory link has it's own depth of sub-folders that…
shampouya
  • 386
  • 1
  • 6
  • 24
1
2
3 4 5