All Questions
1,437
questions
0
votes
0
answers
35
views
Problem with converting Data from Excel in Python [duplicate]
I have problem with converting data to float when reading excel with pandas. Here are the data in Excel (report from SAP):
6.321,68
44,33
40
540,44
excel file image
python is reading data like ...
-2
votes
0
answers
52
views
Use VBA to check range of cells for non-standard Characters
I have several lists of cells in a single column, some of them have non standard characters in them, and I just want to flag each cell like that. There are usually only a couple in each list, but the ...
0
votes
2
answers
57
views
Excel: How to extract a certain word, from a list of words, from a range of cells?
I'm looking to extract the varietal type of a wine, from a list of wine names. There's no formatting consistency. I've got a list of 8 potential wine types (shiraz, rosé, chardonnay, etc.) and about ...
-2
votes
1
answer
28
views
Concatenate the strings to text in a range if the text length is less than 7
I have a range that contains some text. Each text has a length of 6 (ex: "301.12", "301. 84", 301.12") and 7 (ex: "301.134", "301.446", "217.319")...
0
votes
1
answer
61
views
Run-time error '5': Invalid procedure call or argument , When search a string in MS word file in folder and it's subfolders
Basically, I am trying to use VBA to search for a string inside word files in a folder and sub-folders.
I found the below macro, But it raises this error.
Run-time error '5': Invalid procedure call ...
0
votes
1
answer
51
views
Is Excel capable of this
Typically I've always been able to find an example of anything I run into using Excel. However this time I can't find exactly what I am trying to do and am wondering if it is even something that excel ...
0
votes
1
answer
41
views
Excel String counts Alpha or Numeric
I have the following data:
Column ‘A’ is a Numeric Account
Column “C” is the Account related to an Alphanumeric Code in ‘D’
Table of Accounts and Codes
For each Account, I need a count of Codes that ...
0
votes
1
answer
33
views
VBA function FindInRow not always work - Find a cell in an excel row containing either text or date
Sometimes my VBA function FindInRow works, sometimes it doesn’t.
The VBA function FindInRow is used to find if a 'text' exists in an Excel row or not. If the text is found in the row, the function ...
0
votes
1
answer
32
views
How to copy excel cell content to a string with vba
I want to save an Excel sheet as a file using vba code. That I have achieved.
Sheets("html").Select
Dim Path As String
Dim FileNumber As Integer
Dim k As Integer
...
0
votes
2
answers
83
views
Excel: find position of character with specific format in a cell
I have a column of cells with text which I want to sort alphabetically. But not all cells should be sorted by their first characters. In these cells the character by which they should be sorted is ...
0
votes
0
answers
62
views
VBA frustration: Storing integers in an array but VBA thinks they are strings when referenced
In the code below I define the variable TP as an array. The first time TP = Array(Min + 5, Min + Div, Min + Div * 2, Min + Div * 3, Min + Div * 4, Max - 5, Max - 5). When TP(0) is referenced, vba sees ...
0
votes
1
answer
41
views
Changing String value between two underscores
I have string values in Excel like the following:
category_topic1_sports_4
category_topic1_business_4
category_topic1_entertainment_4
category_topic1_gaming_4
Is there a formula that would get rid of ...
0
votes
1
answer
76
views
Error in assigning formula to a column using the F-strings
I needed to replace few columns in the raw data sheet (pivot from this sheet) with formulas.
I have used Xlwings package to do this and it succeeds for other formulas, but not this particular one.
...
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 ...
1
vote
0
answers
53
views
How do I tell pandas not to parse dates from excel(leave the string as is)? I tried every option of dytpe and converters but it still does not work
This is how my excel file looks:
| SNo | Date |
| 1 | 28/2/2024|
| 2 | 29/2/2024|
|3 | 1/3/2024|
etc
So when I read this data into pandas, I want this date string to be
retained as in the pandas ...