find

Hi, I only have Office Professional 2021 so I can't use TEXTBEFORE or TEXTAFTER to extract text strings from string cells. I need to find a string in a string cell and extract that string and all the characters that come after it. Here are some of the string cells I need to extract strings...

Hi All, Thanks for taking the time to review this - appreciated. Just wondering if there is a way to use Ctrl F to find a text string in a column that is created using formulas

XREPLACE is a powerful find/replace solution allowing for replacing by any or all of four categories, i.e. value and/or count and/or type and/or length; single or multiple elements within each category; and control over priorities of all categories I developed XREPLACE in response to feedback I...

Hi everyone, I'm working on a shift planner that will include cells with numbers and text. I want to sum the numbers of these cells that have numbers and text. My shift patterns will follow a strict criteria. Where X is a number: Example 1: X Standard Example 2: X Standard X Lower Example 3: X...

Hello excel experts, I need your help with the following: I have a range named "Database" with about 5000 entries and growing, on the same worksheet I have a small calendar that populates tasks according to the current month and date from the database, this calendar places items for each date...

I am writing a macro( late binding) that runs through a word document and highlight all the values that is contained in my cell range in Excel. I have used the find function which works fine until I add the argument IgnoreSpace:= True, which I don't understand why it's resulting in error...

I have a large Excel data base of bacteria Genus'and i need to match the name in one worksheet, to another worksheet, copy that whole row, and paste into another worsksheet. Example... I have 3 worksheets A, B, C Worksheet A has 1000's of rows of names and many columns of data to each row...

As an example see the 2 sample sheets below. They are silly examples but this is similar to what I need to accomplish. I have a value that is text in an activities column and if there is any match in the text to a lookup value, in the lookup table, then it should return it's corresponding value...

How to change Spreadsheet search (find) results cell border colour ? Seems so easy, but just cannot find anywhere that shows you. Excel 365 currently shows dark green, but with my eyes and screen colours, it looks very similar to the black of the grid lines.

Good Morning I wondering if its possible to create a formula that would split a cell by a comma and keep only the values that start with "TV -". Keep only unique values Take the data and insert a line feed between each grouped value before saving it to the column as shown in the...

Hello guys i have a data base where i want to first find the column header, 2nd in same column find a certain date, and 3rd return correponding date from same row 1st column. So i have prepared one sample excel file Sheet one - Calc - where user can enter the class and dates Sheet two - Log...

Hi, I have a data set of descriptions and I need to find words in descriptions combined with numbers and letters. As an example cell A2 includes a sentence "Repair A4040D" so cell B2 should include information "A4040D". The equipment number is combination of letters and numbers max of 6...

I am trying to find the first empty cell in a row using FIND or MATCH, preferably MATCH. Below are the various ways I have attempted to write the code. in most of the examples I have tried either "" or " " to search. Also with using Find I have tried the search direction of xlprevious and...

I have a spreadsheet that I am trying to populate by using an array formula. Right now, I have a formula that looks in a range and identifies if the word "Spouse" is within it. However, I would like to update the formula to search for "Spouse" & "Ex-Spouse" within the same range, but my current...

I have a list of words in a range and I would like to create a formula to see if those words are within a cell value. Rather than the formula saying TRUE or FALSE, I would like the formula to provide the actual word that it found OR a numeric value for where that words position is in the list...

If I search for this text "GEN2-08C" within workbook and by row using find all, it's not finding the same string on the next tab. They are both text and not a formula. If I only change the search by to columns it then finds both. I have always had issues with the Excel Find tool. Most times...

Hi all, This should be a simple problem but I seem unable to sort it: I have a list of numerical and word product codes in B44:B60, e.g HJK/5566712/19 A macro button on each row can copy the data from B44 over to H44 when sent to another department. Hitting the button again undoes the...

Hello, I'm struggeling a bit to figure out how to solve this issue. I'm trying to compare two data-sets in two different workbooks, where Everything is linked up to an "ID" in column A in "ws" and Column F in "wb1". I want to check if the value in ws column 4 is the same as the same type of...

I have a sample below. I have a string of text and what I'm after is to return the value "H" for the 1st entry below, but, ignoring the first 3 characters and for the 2nd entry return that value of "T",ignoring the 1st 3 characters. I've tried combing the FIND and RIGHT functions without...

Hi i have monthly exercises in my work to find the missing data in two sheets (sheet A and sheet B) and categorize them (for example Hotel, Restaurant, Offices) i want to create an Excel file to find the missing data between two sheets and the result should show the missing in each sheet and...