All Questions
45
questions
1
vote
4
answers
127
views
String expression calculation in excel
I have lines with expressions such as 8,753 - 1,087*4 + 0,1784*5*5 + 0,3447*4*4 in column A
I would like to have VBA calculate resulting value in column B.
Can anyone recommend something?
I tried the ...
- 13
2
votes
1
answer
120
views
How to split a search string into parts, then check parts against a database
Here's what I'm dealing with:
We have a database of machines and their part lists are specified using strings. For example, one machine might be specified with the string &XXX&YYY-ZZZ, ...
- 21
0
votes
1
answer
898
views
Excel: compare two cells containing strings and return TRUE if multiple words match
I am trying to compare two cells containing strings. I can't use VBA for restrictive reasons on my computer so it's just formulas for me. This is what I have:
One cell is there to enter lots of ...
0
votes
2
answers
125
views
Excel formula for string split into specific cell
any formula that works on both excel and googles sheet for splitting text to their column.
I want a formula that split text from string to specific column.
0
votes
1
answer
307
views
Excel Cell reference of a text string + Wildcard?
I have a list of cell with different conditions under a column called "Status".
I am trying to make a summary COUNTIF for each occurrence of a status. Single mentions are easy, like "...
- 161
0
votes
1
answer
180
views
Read in a formula as a string, modify formula, evaluate as a number in VBA
I am attempting to import a string as a formula into VBA, modify that formula based on certain conditions (ultimately to be defined by the user), and then evaluate that formula numerically for the ...
0
votes
3
answers
44
views
Excel - Can't Extract Partial String via known formulas
I know this has been beaten to death but I cannot get mine to work for the below example:
%B1234567^SMITH/MIKE^ABC123DEF456?;1234567=0111000?
A1 contains the above text data and I am trying to copy ...
-1
votes
5
answers
94
views
Extracting text between Number and Parantheses in a String field in Excel
I have a bunch of values like the one below in a text field in Excel and was wondering if anyone knows a method of extracting the Suburb name (i.e. Liverpool) which is usually before the first ...
- 57
0
votes
1
answer
85
views
Extract a List of Values from an HTML string Based on a List of Cell Values
I have an export of our blog, and I'm trying to see which SKUs where listed in that blog post.
I have a list of SKUs and the Blog Content in a spreadsheet. I need to figure out how to get all the SKUs ...
0
votes
1
answer
935
views
VBA How do I conditionally format a range of cells based on the value of one cell in that range?
My goal is to have the text of the entire row turn grey if the value of a particular cell in that row shows "GAT1". I can do this fine with regular conditional formatting but am struggling ...
- 53
0
votes
1
answer
34
views
How to extract a string from 2 strings in Excel counting from the second string instead from the default left side
Here's a string:
Sample text here, EXTRACTTHIS(), and ignore the rest.
I want EXTRACTTHIS() to be extracted, so I used this simple formula:
=MID(LEFT(A5,FIND("()",A5)+1),FIND(" ",...
- 123
0
votes
3
answers
600
views
Excel String lookup within String
i have list of "Place of receipt", i need to lookup with another column with set of list that contains City names in Proper case/ Proper name.
i tried below formula but i did not found any ...
0
votes
2
answers
216
views
Excel formula to extract text from mid
Here, I am extracting middle name from text using below formula
=MID(I2, SEARCH("-",I2) + 1, SEARCH("-",I2,SEARCH("-",I2)+1) - SEARCH("-",I2) - 1)
So from name ...
0
votes
2
answers
442
views
VBA - Passing string variable to formula yields "application-defined or object-defined error"
I'm experiencing the following issue:
Sheets("Workbook 1 ").Range("N" & integerv).Formula = "=Workbook2!""" & column_string & """ 3)&...
- 13
0
votes
2
answers
141
views
Excel - Function To Count All Strings In Range
I'm looking for a function that would count all of the different occcurrences of different strings within a range. It would go through an input range, cell by cell and, for each unique value it finds, ...
- 781