Get instant live Excel expert help to learn how to use Search function in Excel?
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
I have a column where each cell has letters and numbers. The numbers would range from 10 through 18. I would like to find a formula where I can search the cell for any one of the numbers and return a value from a different cell if it finds one.
I currently search for a specific number and the formula works but only for that particular number. The formula I currently have is: =IF(ISNUMBER(SEARCH("16",F10)),G10,"") This does work if it finds the value of 16 in the (F10)cell and then places the value from cell "G10" as the result. If it doesn't find the numbers, it will leave the resultant cell blank.
Solved by O. H. in 19 mins
I need a formula that will search for the date from Sheet1 A1 in Sheet2 Row 1 (C1-AL1) then find a number 1 in the column below that date and then retun the name in column A Sheet2 to Sheet1 cell B2 please.
Solved by Z. U. in 16 mins
i want =IF(ISNUMBER(SEARCH("borkonda",I7)),"53", this formula. it can work only 8 function. but i have 21 function. i need help
Solved by M. J. in 26 mins
I have a formula that was created by you guys
=CONCATENATE("<html>", " ",MID(C1,SEARCH("<h5>Item Description</h5>",C1),SEARCH("<!-- LISTING TERMS TEXT GOES HERE -->",C1)-SEARCH("<h5>Item Description</h5>",C1))," ","</html>")
Which takes out certain paragraphs, texts, sentences and preserves the paragraph I need. I need either a revision of the formula so i can apply it to future sheet and make it a universal formula. OR.. I need step by step on what to input to make this formula work.
So the sample column I am showing is all html cells. And they are once cell from each different excel sheets to show that the formula needs to work for each cell while i input the right text in the formula).
EXAMPLE OF FORMULA USED
First cell (c1) shows the cell that needs to be modified and (d1) uses the formula and shows which text is preserved and others are omitted.
=CONCATENATE("<html>", " ",MID(C1,SEARCH("<h5>Item Description</h5>",C1),SEARCH("<!-- LISTING TERMS TEXT GOES HERE -->",C1)-SEARCH("<h5>Item Description</h5>",C1))," ","</html>")
I pasted formula again and the last session the expert told me the three search terms is where input some of the words to make the formula work.
So hopefully you can help me with A3 to A14 on what to input for each individual cell. (as mentioned the each cell is representation of a sheet that has lot of data)
Solved by T. L. in 19 mins
I need a modification of this formula to work on other cells
I tried on few other cells on sample file I attached but run into problems. Please help.
So the formula basically preserves certain texts and deletes unwanted texts.
formula is
=CONCATENATE("<html>", " ",MID(C1,SEARCH("<h5>Item Description</h5>",C1),SEARCH("<!-- LISTING TERMS TEXT GOES HERE -->",C1)-SEARCH("<h5>Item Description</h5>",C1))," ","</html>")
I will explain further details. But please make sure you know (C1) (which is the source cell) and (D1) (outcome cell) cell example before accepting this task to save time
Solved by Z. S. in 13 mins
I have multiple excel sheets with un-formatted data, about 3000 sheets. Each sheet has been obtained from converting PDF files to excel sheets. So data is not in any particular order in cells or rows. I need to extract data from all the sheets to one organised sheet. Good thing is I need only 4 results. Which I can search using the search option in the excel. Purchaser Name, Mobile, Email and Address. I don't want to copy paste data individually. Nor can use traditional excel formulas because they aren't in the same rows or columns. How do I do this??
Solved by M. S. in 23 mins
how do I search and delete duplicate addresses in an excel spreadsheet
Solved by X. J. in 14 mins
Hi, I need a formula that when given a date will search a specific row of dates to find the match, then in that dates column find a number (1) then in the row that the number is in, return the name that is in the first cell of that row. hope you can help.
Solved by F. H. in 11 mins
I need help with an IF function. Need the if and statement excel to search all of the cells in its column before it and use the highest previous data point
Solved by V. J. in 22 mins
I have an item in one cell that looks like this "Clear Drive () Clear Walks () Salt Drive () Salt Walks ()" I have hundreds of these items that all have () to indicate where the price goes next to that part of the item.
Then in the next 4 cells I have 4 different numbers.
How can I do a formula, that will take each of the 4 cells with numbers, and insert itself into each () in order. I want it to search for the () and insert itself so I can use it as a blanket formula for all the items.
Solved by O. E. in 14 mins