Stack Overflow
Stack Overflow

Questions tagged [text-to-column]

72 questions
0
votes
0 answers

How to convert a text into a tabular format

I want to convert a txt file into a tabular format. I used pandas to skip rows but I want a way that will be generic not by skipping rows: This is the txt file: Interface Status Protocol Description Vl1 …
Ibrahim mostafa
  • 9
  • 7
0
votes
1 answer

Excel - Delimiter: Text to columns grouped by value

I have the following column and I am trying to separate the texts into columns by value: red red, blue blue, green red, blue, green blue green However, when I use the ordinary text to column function I get the following: red red blue blue …
Anonymous
  • 21
  • 4
0
votes
3 answers

Split a string by a eliminator into an infinite number of columns

I have a database export of user ids and dates logged in. structure(list(User.Id = c(2542573L, 2571394L, 2770912L, 2683246L, 2832110L, 2773277L), Days.Played = c("", "2020-01-15,2020-01-16,2020-01-21,2020-01-22", "2020-06-29",…
Nick
  • 13
  • 1
  • 5
0
votes
1 answer

Replicate the right justification that ls does when using ls twice

If I have two files, tmp.txt and tmp.pdf, one large and one small, when I type ls -al tmp.* everything is nicely right justified and I get this output -rw-r--r-- 1 simon simon 615316 Oct 17 20:55 tmp.pdf -rw-r--r-- 1 simon simon 0 Oct 17 20:55…
Leo Simon
  • 186
  • 1
  • 9
0
votes
1 answer

String split issue in R preprocessing data for GCalignR

Trying to take multiple .txt (GC-FID) files, pull out two columns of data and assign them to an object I can eventually pass to GCalignR. Is there a better way to process this data for GCalignR? Auxiliary functions causing issue: ''' # nonempty…
fppatho
  • 1
  • 1
0
votes
1 answer

Separating multiple columns with comma separated values at once in Excel

I have an excel sheet with comma-separated values in 35 consecutive columns. I want to separate the comma-separated values into columns for all 35 columns at once. Is there any code or shortcut to that? At present, I first enter a new column next to…
Muhammad Usama Ashraf
  • 41
  • 5
0
votes
2 answers

Create separate column based on email address, using Excel or SQL

I have a column in Excel with the following Employee Mickey D. Mouse mickey@disney.com I want it to look like Employee || Email Mickey D. Mouse || mickey@disney.com In Excel, if I use Text to Column it looks like this Mickey || D. || Mouse ||…
SnowboardBruin
  • 3,645
  • 8
  • 36
  • 59
0
votes
0 answers

Text to Columns with blank cells

I saw the Post of J.Con about the text to column loop (Text to columns for multiple columns - Excel VBA). However this only works if the first row has all the information, like in first picture: So I changed the code so it is working like in the…
Wouter Groeneweg
  • 43
  • 1
  • 8
0
votes
1 answer

VBA to convert text to columns in multiple sheets except one

I am new in VBA coding and and am trying to convert text in all sheets except one to text but have not achieved success. I have text in column A of each sheet and number of rows might differ. This is what my code looks like Sub…
nidhi agrawal
  • 3
  • 1
0
votes
1 answer

I want to eliminate exact range (G1) & make this Text to column code dynamic to convert column values to date

ActiveCell.EntireColumn.Select Selection.TextToColumns Destination:=Range("G1"), DataType:=xlDelimited, _ TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=True, _ Semicolon:=False, Comma:=False, Space:=False,…
H.K.
  • 3
  • 6
0
votes
0 answers

vba loop text to columns date format

I am self taught and relatively new to VBA! I have learned many things from your site, but now I am stuck. I receive multiple files that have multiple columns of what should be dates. The files are originally exported in CSV format and opened in…
treptara
  • 1
0
votes
1 answer

group separator in excel

I would like to add group separator to a column of texts with numbers in it, e.g. from 78898 (30.18%) to 78,898 (30.18%) but the NUMBERVALUE function didn't work. And if convert using the "text to columns", then (30.18%) will be converted to…
lele
  • 25
  • 4
0
votes
3 answers

Running text2column for column A:A

I am quite new to VBA scripting, but I have to perform the following actions: convert a csv file to xls one in the saved xls file to perform the following actions: 1. To run Text To Columns for the data 2. To define the type of…
YN.
  • 27
  • 5
0
votes
1 answer

Text to Column (Date) using current year instead of the timestamp

I'm using text to columns as part of a VBA macro to separate timestamps into 2 other columns. When I format Column B to dd/mm/yyyy it uses the current year 2020 instead of 2019. Is there a way to adjust my macro to pull the year from the original…
Paul
  • 5
  • 2
0
votes
1 answer

After copy and paste values from one workbook to another, a formula doesn't work with a specific range until I doubleClick cells

Using VBA I open one workbook, copy data and paste it to another workbook. In the second workbook I set a formula for specific range of custom format of values(dd/mm/yyyy hh:mm) but the formula doesn't work. Values are kept on the left side of cells…
matheonidas
  • 3
  • 2
1 2
3
4 5