Stack Overflow
Stack Overflow

Questions tagged [text-to-column]

72 questions
3
votes
1 answer

Excel VBA Text To Columns

Good Morning and thanks in advance, I am trying to run a VBA macro to enable my end users to scan barcodes into excel then using a command button split the barcode into its component types using the text to columns vba macro, which then breaks it…
Martin Scott
  • 33
  • 1
  • 3
3
votes
3 answers

Counting the position of a character after two or more spaces

I am trying to return a value equal to the position of the first letter coming after two or more spaces. I have a tool that extract tables with variable column length into TXT docs. I need to get these tables into an Excel sheet without having to…
Karim Daoud
  • 53
  • 5
3
votes
1 answer

Separate line breaks into columns

I have one cell with text. The text string looks like the following: Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text. I read to use Text-to-column, use as…
Carol.Kar
  • 4,581
  • 36
  • 131
  • 264
2
votes
1 answer

Snowflake - how to split a single field (VARIANT) into multiple columns

Within Snowflake how could I split a string of data that's in a single field into multiple columns? This field is in a View and a type of Variant. My View that I'm querying has 12 actual columns. 1 of those columns is a large string that I'd like…
RPAR
  • 23
  • 3
2
votes
1 answer

How can I convert a table that have being copy-pasted to a pandas DataFrame?

How can I convert a table that have being copy-pasted to a pandas DataFrame? As an example, I have the following table that have being copy-pasted: Step Training Loss Validation Loss 5000 8.524000 6.308433 10000 6.043500 …
Guilherme Giuliano Nicolau
  • 143
  • 1
  • 11
2
votes
1 answer

How can I create a macro to perform a TextToColumn on the column I'm currently selecting, Destination must be same Column

I want to create a macro that performs the TextToColumns on the current selection and place destination on the same column. I tried the code below, but it doesn't work. What would be the correct way to set the column as a variable for the column I'm…
Lucas Pedroso Santos
  • 367
  • 1
  • 3
  • 9
2
votes
2 answers

How to have the last column inputted in your array for text to column?

So essentially I have a large amount of data all in 1 cell seperated by commas. I have multiple rows of this data and with different amounts of data in each cell. Ex: first row may have data seperated by 3 commas, so it will become 3 columns.…
Joel Bastien
  • 121
  • 2
  • 11
2
votes
2 answers

Text to columns - Uniform response with different numbers of Spaces

I have a spreadsheet where column A is a list of names. Some of these names have titles (e.g., Mr John Doe, Miss Jane Doe, Mrs Jane Bloggs, Cllr Joe Bloggs etc) some of the names do not (just Joe Doe, John Bloggs, Jane Doe etc). I've been asked to…
S Scott
  • 23
  • 3
1
vote
1 answer

Convert Text to columns in Excel using VBA for dynamic columns and Rows

I have a report wherein i need to do Text to columns for dynamic columns( columns are usually around 24-30 months). I have used the macro recording to currently perform text to columns only for fixed columns. Expected result - I need help in getting…
Divaansh
  • 17
  • 5
1
vote
1 answer

How do I split text to columns in Pandas without getting "Columns must be same length as key" error message?

I tried splitting one dataframe column into two based on "-" as a delimiter, and I'm getting a ValueError that reads "Columns must be same length as key," even after following multiple tutorials online. The dataframe is named "epl_results_2015_22"…
michaelkhos
  • 11
  • 1
1
vote
0 answers

TEXT-to-COLUMN xlDMYFormat date format error

I'm trying to do a text to column using "!" Char. Columns("A:A").Select Selection.TextToColumns Destination:=Range("A1"), DataType:=xlDelimited, _ TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=False, _ Semicolon:=False,…
Cris_rw
  • 11
  • 2
1
vote
1 answer

Running same VBA code for a range of columns (one column at a time)

I have a range of dates which I need to convert to 'MM/DD/YYYY format (but as text) every month. I used to manually convert these by using this formula =TEXT(Cell Ref.,"MM/DD/YYYY"). See picture above. I have recently started using below VBA code…
ram singh
  • 41
  • 8
1
vote
2 answers

Split cell value that based on a delimiter and insert to a new columns

The header should be written to each new column inserted, and the cell value should split by the "," delimiter. Example: Before: Header name another columns from right... value1 value1,value2,value3 value1,value2 After: Header…
User1
  • 85
  • 2
  • 15
1
vote
2 answers

VBA code for "Text to Column - Fixed Width" - loop

I am looking to find a way to make my code more simple, more efficient and create a loop that will be running until it reaches the last character. First, I am getting data that always looks like the example below and should be pasted in a row…
okopz
  • 13
  • 1
  • 3
1
vote
1 answer

Convert .csv file into columns with python

I have a .csv file in which data is separated by commas and I want to separate it into columns. For this, I am trying to put every row element in a list and then put them into columns in a new file. The code I'm using is the following: import…
Alex
  • 35
  • 2
  • 6
1
2 3 4 5