text string search

Trying to use index(match to bring over some data from one sheet to another one. Part of the criteria is based upon text found in a string. I was hoping to just use wild cards but it appears, after trying a few times, that it isn't working. Where am I going wrong? On sheet1 in cell D2 I am...

Hi, I'm making an English teacher making quizzes based on lists of sentences with translations. I want to make one formula that takes the text string of another cell and randomly replaces one word with an underscore ____. I'd also like to make a formula that replaces all the words with...

Happy Monday Everyone I can make my way around excel (just), but once I figure out a way to get something working, I usually leave it there. I created a formula to build a Sheet VKUP_PAGE to use as a VLOOKUP table and return one of 3 variants of the following examples in Sheet TESTPAGE...

Hi! So I have been pulling my hair our trying to figure out how to build a <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250...

Using Excel 2013 in Win 8.1, I would like Excel to find out if a country is mentioned in a list of newspaper headlines (column A) - and return the result in column B. I have a list of all the world's countries (238 of them) in another column (C), and I would like Excel to check from this list...

Dear sir/madam I'm wondering is there any way to parse the text in Excel. In a tedious process, this problem is one which is consuming most of the time. I read PDF Form's to Excel files and then process it. Problem: I'm reading a Text Field from PDF Form using VBA, to an excel cell, where the...

I need to lookup the codes in the parentheses, and if present, return the value in column E. The values would be returned in a summary table on another worksheet. As an example: Lookup "searbora" text in column A. If found in the cell, return the value located in column E. Thanks so...

I have a problem in Excel to which i seeking a solution. I have imported some External data using the Query option and I am able to Refresh it as and when I want. In another location in the file, I have given reference to a particular cell that I am importing (eg. on Cell A3 I am saying =G121...