All Questions
408
questions
1
vote
1
answer
45
views
Splitting up a variable range of time into multiple cells
I need to split up a range of time from a variable input in excel, for example
Start
End
11:00:00
13:00:00
I would like to have the input split up in segments of 30 minute intervals (input is only ...
0
votes
1
answer
31
views
Split out numbers in a column
I'm trying to split out the two numbers in the cell into separate columns
I've tried "text to columns", using the delimitator "space" but it removes the second number in each of ...
-1
votes
0
answers
46
views
EXCEL a dynamic solution for searching through 3 different arrays
I have so far all the names of teachers who match students post code, subject and age phase using TEXTJOIN.
I have then used TEXTSPLIT to separate the teachers names into columns.
Under the PostCode I ...
- 1
0
votes
1
answer
44
views
Is there a way to split a cell after two paragraphs; merge into new row
I have a spreadsheet full of data. In column "H" I have cells upon cells of between 3-7 paragraphs. Ideally I would like to split the cell into 2 paragraph max length cells and merge the ...
0
votes
1
answer
51
views
VBA, convert cells with several paragraphs of text ->splitting paragraphs down into new cells
I have a spreadsheet with data like this:Spreadsheet Overview Image
In Column "A" I have multiple cells that are multiple paragraphs. Ideally my goal is to break each cell into multiple ...
-1
votes
2
answers
64
views
Split and paste columns as soon as value changes
For a new project, I have a large data set, containing 9000+ rows in column I-L as shown in the figure. As soon as the value (default 4.13) of column >5, I want the columns I-L to be split at that ...
- 59
1
vote
0
answers
16
views
How to cut xlxs file into several segments according to the index and create a list with the values of each segment
So, I'm analyzing an xlxs file with a few minutes with around 300.000 lines, a large part of which doesn't interest me, it's noise. Using the find_peaks function, I can now filter which time intervals ...
1
vote
1
answer
22
views
Excel VBA search for data and stuck at a certain point due to group or split source file?
I have below code which quite simple maybe not the most elegant but works well with a small mistake what I cannot handle. Source excel file is something which I am using with group and split in 4 on ...
- 27
0
votes
2
answers
54
views
Excel split text keeping font color
I'm trying to separate text within cells into different cells keeping the font color on each letter.
Ex.
|Holy Smith (Blue), Jack Thompson (Green), Adam Mills (Red)|
into |Holy Smith (Blue)|Jack ...
0
votes
0
answers
49
views
VBA | type mismatch error at Split function (Solution is to separate the declaration)
Good day to all,
In a cell, user can enter the names of the Traders. They can enter 1 or many names, and names are to be separated by comma.
E.g. 1 (If only 1 Trader)
Tom
E.g. 2 (If >1 Trader, ...
- 353
0
votes
1
answer
84
views
Extracting text after nth of a character and put in next row , under first row in Excel VBA Code
I'm very new in VBA maybe can some one help me with my problem.
I have in my rows (this example)
A1: 52/ATL/340/M/50/C
A2: 52/IST/620/M/DBX/200/D
I need first split after 4th "/" to the ...
- 3
1
vote
0
answers
18
views
Put data from File1 to particular sheet of File2 using Python
Problem Statement:
I need to split an Excel file (File2) based on unique values in the 'Vendor Name' column and save each subset as a separate file in an existing sheet 'Data Dump' of Excel workbook (...
- 45
1
vote
1
answer
62
views
Duplicate File1, Split File2 by vendor, Paste splitted data to duplicate file1
Problem Statement:
I need to split an Excel file (File2) based on unique values in the 'Vendor Name' column and save each subset as a separate file in an existing Excel workbook (File1). However, my ...
- 45
1
vote
1
answer
147
views
Split Excel file into multiple files using Python
I have an Excel spreadsheet with almost 40,000 rows of entries. I would like to split this Excel file into multiple files based upon the values in Column C starting with Row 6. I've been able to ...
0
votes
2
answers
424
views
Excel :: split string only by the first occurrence of a delimiter
I have this file that I copy/pasted into Excel.
Sometimes the rows look like this:
귀신 신 (spirit, ghost)
And I have to split by the character (
But sometimes the rows looks like this:
눈 설. Snow
...
- 11.3k