Input:C1 Mary went down the and hurt her head D1 hill
Desired Output: Mary went down the hill and hurt her head
Below is the best what I can describe the logic as:
(If C1 contains "keyword") (Separator " ") concatenate [D1] as "[C1...Keyword][Separator][D1] [Rest of C1]"
Below is the...
good day
im trying to search data after navigating to the website and then entering input into the search field
following is the html code
first selecting "Search Cr" from drop dow
<!-- Dropdown menu Start -->
<div class="bs_LblockDropdown_App1 bs_LblockDropdown_Common" id="Div10">...
Hi,
Could you please help me finding excel formulas for the following problem?
I have the following cells on the same column (column A, rows 1-5):
A
1 00:30 random1 !day random6
2 01:00 random2 !day
3 02:00 random3 !night
4 01:15 random4 !night random7
5 00:15 random5 !day...
Hello,
I have 6 keywords that I would like to cycle through with the following code but I can't seem to get it to work. Any ideas?
Sub ChangeLinks()
Dim wb As Workbook
Set wb = Application.ActiveWorkbook
Dim Path As String
Path = Application.ActiveWorkbook.Path
Dim NewName As String
Dim...
Hello All -
You were extremely helpful on my post about looking through multiple columns to see if a keyword was in there, but was wondering if you could help on this. The below is the formula you provided on my original post accomplished finding if a certain keyword was in columns H3 - R3...
Hello Excel,
Looking for some assistance on the following problem:
I have a keyword in column "E" that goes down approximately 4,000 rows.
Columns A - D have the following rules
1. They contain no text
2. They contain the specific keyword in column "E"
3. It contains the specific keyword...
I have the below code that returns what I want. But it returns it to Column A. How do I get it to return the data starting in Column B?
Thank you,
Clint
Sub EFP()
Dim keyword As String: keyword = Sheets("Results").Range("B3").Value
Dim countRows1 As Long, countRows2 As Long...
Hello guys! I am currently doing a qualitative analysis of short comments. I have created a spreadsheet with comments as rows and categories (or 'codes') as columns; so that for the comment "I like ice cream and tea", I will tick the category "food" and "beveridge" ("ice cream" being included in...
Greetings,
I have been looking through the forums for an example, but i can't find exactly what I am looking for. I am looking for VBA to run through my sheet and remove rows that contain a certain keyword (override) in a certain column (F). The thing that is tripping me up is that the...
Hi all
I am trying to draw data from a webpage, i need to get that data into excel and make a search (e.g. India, United States, China) run automatically on the data so that when a keyword is found, it is equivalent to a specific value (e.g. Indian Rupee, USD, Chinese Yuan).
Help please Im...
Hi All,
I think my formula is wrong, but not sure where or how to do it to make it show NA at K12.
It suppose to show NA when J12 is empty and N12 has the keyword exchange...
I need to copy the value of a cell if the contents contain a keyword from a list in a Sheet I have.
You can see an example and make a copy here
https://docs.google.com/spreadsheets/d/1Fmn6UtJ8QbRGsGYVgVcUpfg_kmCVk4MLGhNDBVtAxJk/edit?usp=sharing
So if the news story listed in "RSS News Feed"...
I am quite new to coding and have the following issue: I want to write a macro, that goes to the website: https://displaypurposes.com/ inserts a keyword and copy the results into my excel sheet.
This is how my code looks at the moment:
Sub DisplayPurposes()<code style="margin: 0px; padding: 0px...
Hi All,
I am using the code below to search for a keyword in a string against a list of keywords located in another tab, if the word exists then the row is copied over to another sheet.
The code works, however it has to be run twice to complete successfully. I am using a nested For Each Loop...
I have 2 columns of data, one with a product description and the other with Keywords that apply to that product.
Currently, the Keyword contains words that are also found in the Product Description. I need to create a new Keyword column that excludes those words. I don't want any whole...
Hi Friends,
I am bit confused as this keyword("continue") exits or not in VBA. Then after googling I found this link
https://docs.microsoft.com/en-us/dotnet/visual-basic/language.../continue-statement
Here they have mentioned the use of this keyword. But when I tried to implement that it is...
Hi,
Dont know how to go about doing this or if its even possible.
Example
DataFolder (full of userdata sheets same format)
I want to input a name, and macro to search through all the sheets in a set folder and get all the rows of that user from sheet1.
Thanks for any help
Hi everyone :)I have this problem at work with a massive list of keywords that i need to find and match to another list.Creating the right formula will save me like 10 hours of work, so i would be extremely thankful for a solution.I have 2 list of keywordsbut i can only find part of the keyword...
Hi,
I am stuck here with below query.
I have one excel data sheet1 column "E" I have data and in "sheet2" in column A I have some keywords. I want a macro to copy the keyword from sheet2 and search that keyword in sheet1 (contains) and next to the same I need macro to write "exclude". Now I...
Hello,
I am attempting to use a formula that will search for key words in text fields of cells and return the appropriate category>
<colgroup><col><col></colgroup><tbody>
=INDEX(CATEGORIES,MATCH(TRUE,ISNUMBER(SEARCH(KEYWORDS,A2)),1))
I am using this formula. But keep getting an #NA...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.