I need advice on a formula to find a specific string in an Excel Spreadsheet and list all cell contents that have that string.

I need advice on a formula to find a specific string in an Excel Spreadsheet and list all cell contents that have that string.
by

1 Answer

Answer :

You might be able to use the find function =Find(thing_to_find,source) which returns the position of the thing you’re looking for within a string in conjunction with Excel’s string functions to extract it once you know its position. This may point you in the right direction. Agree w/ poster below a more specific example would be helpful.
by

Related questions

What is the strangest Excel spreadsheet you have seen?

Description : What is the strangest Excel spreadsheet you have seen?

Last Answer : I've used them to map dollhouses, and to create level maps for computer games, for population models, economic models, experience models, for military simulation scenario data, to make maps of game ... they started wanting you to subscribe to Office. I have used Open Office or Libre Office instead.

Is there an Excel formula for calculating a length of time and converting it to decimals?

Description : Is there an Excel formula for calculating a length of time and converting it to decimals?

Last Answer : answer:If you are keeping time to the quarter hour, then the decimals are really decimals: i.e., hundredths of an hour. So you don't need a formula. It's simple subtraction, the same ... as you stick to quarter hours and use decimals, those numbers are great tools for several work-related purposes.

Best excel formula to put daily data into weekly data?

Description : Best excel formula to put daily data into weekly data?

Last Answer : Depends on the version of excel If you are using the 2007 version, you can simply use the SUMIFS, AVERAGEIFS, COUNTIFS, etc. functions. Link to MS Explanation If you are using the 2003 version, you will ... 24/09, etc into 10/19/09. This could be done by the DATE function and the WEEKDAY function.

How do you develop a unique list of items in excel?

Description : How do you develop a unique list of items in excel?

Last Answer : Ok, so highlight the cells that contain the data. Then in the menu bar, go to Data - Filter, Advanced Filter. Choose Copy to another location , check the box labeled Unique records only , and ... to the first question. (Menu may slightly differ if you're not using Office 2007) Hope this helped!

Convert Excel cell data to a column header?

Description : Convert Excel cell data to a column header?

Last Answer : answer:From your question it's not entirely clear to me what you want to do. Obviously you want to differentiate one product (Product ID) from another. So, do you just want to change a listing that ... the Find text with , leaving you with only the product ID values. Was that what you wanted?

Did you know there is an E-sport competition for Microsoft Excel?

Description : Did you know there is an E-sport competition for Microsoft Excel?

Last Answer : I didn’t know. I might watch a bit of it.

Combining many IF statements in excel?

Description : Combining many IF statements in excel?

Last Answer : Try this? link I did a search on Google – “combined IF Excel” and there were oodles of results.

In Excel, how do I conditionally change a row's fill color?

Description : In Excel, how do I conditionally change a row's fill color?

Last Answer : you have to “make new a rule” under “conditional formatting”

How do I do this in Excel? (please see details inside)

Description : How do I do this in Excel? (please see details inside)

Last Answer : I don't have it in front of me, but I'm seeing 0 answers so far, so maybe get you started. I think the easiest way to do this is with conditional formatting , which is pretty simple to use, but I' ... NO as well) and whitespace (require no to be the complete cell). Hope it helps get you going.

Can you assist with an Excel output question?

Description : Can you assist with an Excel output question?

Last Answer : If I understand you, you want to transpose. Select your data, CTRL-C to copy, then right-click on another sheet and select the transpose button. It will make this look like this. Is that what you mean?

Anyone know how to use excel to create tax spreadsheets but on mac numbers?

Description : Anyone know how to use excel to create tax spreadsheets but on mac numbers?

Last Answer : I'm not certain of exactly what you're asking here (and I don't do Excel on a Mac in any case), but it seems that you want to have a cell - that is, a single cell - to calculate and add ... original value + the amount of the first tax, then the formula will be different, but you'll have to say so.

Can I insert multiple blank rows on an excel sheet?

Description : Can I insert multiple blank rows on an excel sheet?

Last Answer : Yes. Highlight a cell, then drag it down (highlighting) for the needed number of rows. Then select insert rows. It will insert the number of rows highlighted.

Simplest way to convert a row into column in Excel?

Description : Simplest way to convert a row into column in Excel?

Last Answer : answer:Hi @Sassy009, welcome to ask-public! In Excel that is called Transpose. Here’s an explanation from Microsoft. Switch (transpose) columns and rows

Can a newer version of Excel read a file created in an older version of Excel correctly?

Description : Can a newer version of Excel read a file created in an older version of Excel correctly?

Last Answer : Should work in newer versions.

How can I make this sort of a ...script, in excel?

Description : How can I make this sort of a ...script, in excel?

Last Answer : You could simply graph them on the same chart. Once the sheet is set up that’s about all that would need to be done. You would not have any fancy transparency though. I would probably just write a small program in Java to do it.

How can I pull data from one Excel worksheet to another based on matching Part Number?

Description : How can I pull data from one Excel worksheet to another based on matching Part Number?

Last Answer : answer:The Vlookup function is what you seek. Example: Book1 has a list of part numbers 1 2 3 4 5 Book2 has a list of part numbers,with product name 4 tchotchke 2 gizmo 5 trinket 3 thingy 1 doodad ... have to be in any particular order on either sheet. (if you use that FALSE argument at the end).

Omitting columns in Excel 2010 sort?

Description : Omitting columns in Excel 2010 sort?

Last Answer : answer:highlight the columns you want to make disappear right click on one of them choose HIDE from the context menu,] Voila…

In Excel, how do I get what I type onto page 1 to repeat onto page 2, page 3, page 4, etc.?

Description : In Excel, how do I get what I type onto page 1 to repeat onto page 2, page 3, page 4, etc.?

Last Answer : You type the information into a cell on the first sheet then link the cells in the other sheets to that cell. So if the info is in cell A1 on the first sheet type (=Sheet1!A1).

When making a chart in Excel, how do I put a heading at the top of the page?

Description : When making a chart in Excel, how do I put a heading at the top of the page?

Last Answer : Insert -> Header & Footer

How do I set tab order in Excel?

Description : How do I set tab order in Excel?

Last Answer : answer:If you can't unlock the protection, then you can't move the tabs. It's as simple as that. That's why Workbook Protection exists. Now, if you would like to bypass Excel's security and ... t think are so simple) then there are any number of downloadable macros that you could find to do that.

How do I find multiple values in Excel?

Description : How do I find multiple values in Excel?

Last Answer : answer:Your problem is stated in a confusing way. If you have a list of bogus Area Codes , then why do you need to look anything up? You have what you want. On the other hand let's say that ... as the phone numbers already will be. Text strings won't look up into (and match) number values.

How do you sort columns of number/text mix in Excel?

Description : How do you sort columns of number/text mix in Excel?

Last Answer : answer:Make the numbers all 2 digits…. example-01 example-02 example-03 example-10 example-11 example-12 Then it will sort correctly.

How do I convert UK date format to US date format in excel?

Description : How do I convert UK date format to US date format in excel?

Last Answer : answer:Chances are, Excel is seeing those dates as plain text instead of as date objects. You can confirm this by widening the column with the dates are they left-justified? If yes, then ... provide the answer. Or you can see the same instructions online: Convert dates stored as text to dates.

Online tutorials for PowerPoint and Excel?

Description : Online tutorials for PowerPoint and Excel?

Last Answer : Here is the tutorial on PowerPoint & Here is the tutorial on Excel.

How can I fix this problem in Excel?

Description : How can I fix this problem in Excel?

Last Answer : Right click on the cell and go to format cells, and then select dates and pick what you want.

Excel graphing of dates and times?

Description : Excel graphing of dates and times?

Last Answer : The date and time formatting looks the same in all three cases. You can manipulate how the date is displayed using various date/time functions. I'm not getting what the problem is. Can't you ... the x axis and the corresponding data that changes with time on the y? Seems pretty straight forward.

How can I average non-adjacent cells in excel, excluding zero?

Description : How can I average non-adjacent cells in excel, excluding zero?

Last Answer : I copied your formula and it’s working for me in Excel 2007, =SUM(B2,D2,F2,H2,J2,L2,N2)/COUNTIF(B2:N2,”>0”)

Excel Question: How can I take firstname, lastname in one column and separate into two columns?

Description : Excel Question: How can I take firstname, lastname in one column and separate into two columns?

Last Answer : answer:Assuming you have a space or comma between the first and last names, you can use Data / Text to Columns. (I'm still using Excel 2000, so your commands on a more recent version may be ... as space , or comma, or whatever it is. The text will be broken into separate columns automatically.

Does Excel provide an easy means of bookmarking worksheets?

Description : Does Excel provide an easy means of bookmarking worksheets?

Last Answer : Two ways to go about this depending on the version of Excel you have I believe if you have 2003 or great there are thumbtacks to the right of the document if you click this thumbtack it ... accessed documents and put shortcuts in their to your well frequently accessed documents. :) Hope this helps.

In Microsoft Excel, can you change the settings of the representative bars so they are not all the same colour?

Description : In Microsoft Excel, can you change the settings of the representative bars so they are not all the same colour?

Last Answer : If they are in the same data set, they will be the same color. If you plot more than one group of data, then the different sets will have different colors. Say I'm plotting fruit sales at ... there would be one bar of each for each month with a magnitude proportional to the number of fruit sold.

How do I make an excel sheet print horizontally instead of vertically?

Description : How do I make an excel sheet print horizontally instead of vertically?

Last Answer : Go into the print dialog. Select the Properties button. Then select Landscape under Orientation.

In excel how do I keep words from overlapping? ...

Description : In excel how do I keep words from overlapping? ...

Last Answer : Right click. Format cell. Alignment tab. Check the wrap text box.

MS Excel Help: Calculate Amount of Time?

Description : MS Excel Help: Calculate Amount of Time?

Last Answer : If your timestamps are in columns A and B, I'd imagine this would do the trick: =B1-A1 and then make sure to set the cell format to time, showing the difference in minutes and seconds. Just tested with this: timestamp A ... = custom: dd/mm/yyyy hh:mm:ss) =B-A: 0:29:57 (cell format = custom: h:mm:ss)

How do I add a secondary x axis to a chart in excel 2008?

Description : How do I add a secondary x axis to a chart in excel 2008?

Last Answer : Click on the chart, then go to chart type, Custom Types, Line -Column on Two axes.

Does Excel allow you to format cells to view in standard form?

Description : Does Excel allow you to format cells to view in standard form?

Last Answer : Change your settings (format->cells) to something that will display easier. It’s currently rounding. I’m not in front of my computer, but you can format the cells to show data any way you like.

How do you convert decimals to seconds in Excel?

Description : How do you convert decimals to seconds in Excel?

Last Answer : Right click the cell. Choose Format Cell. Choose custom format. Type m.ss Click Ok.

VBA excel?

Description : VBA excel?

Last Answer : You’re declaring a string variable.

How Can I effectivly use Excel?

Description : How Can I effectivly use Excel?

Last Answer : This might help. Pic You can use the COUNTif function to count how many times a number shows up in a row or column. For example: =COUNTIF(A1:A19,1) will count how many times the number 1 appears in cells A1 to A19.

How do you use wildcards in Excel?

Description : How do you use wildcards in Excel?

Last Answer : I don't know about excel, but if I remember correctly Open Office uses regular expressions for it's searches. In regular expressions __asterisk__ means match zero or more of whatever precedes. If you want to ... ) I hope that helps. I'm going to install it on my current computer and try it out.

How can you copy dates easily using Excel?

Description : How can you copy dates easily using Excel?

Last Answer : What little plus sign are you referring to?

What app can I use with my iPhone to edit Excel spreadsheets ?

Description : What app can I use with my iPhone to edit Excel spreadsheets ?

Last Answer : answer:Google Docs allows the editing of Excel documents on your iPhone. The caveat is that you must upload it via your desktop first. www.google.com/docs

If you encrypt an Excel file in a folder on your desktop, what does that mean? that the file is safe from hacking?

Description : If you encrypt an Excel file in a folder on your desktop, what does that mean? that the file is safe from hacking?

Last Answer : Safe from the average nosy person? Probably. Safe from some who knows what they are doing and really wants it? Probably not. It depends on how it was encrypted and how bad someone wants it.

In OpenOffice Calc how do I format a cell as a number?

Description : In OpenOffice Calc how do I format a cell as a number?

Last Answer : Are you by chance visually impaired?

What displays the contents of the active cell in Excel: a) Name box b) Row Headings c) Formula bar d) Taskpane e) None of The Above

Description : What displays the contents of the active cell in Excel: a) Name box b) Row Headings c) Formula bar d) Taskpane e) None of The Above

Last Answer : c) Formula bar

Do you know a good desktop/blackberry program to organize passwords?

Description : Do you know a good desktop/blackberry program to organize passwords?

Last Answer : answer:If you’re on a mac 1Password is the best, but it doesn’t offer BB sync. There is lastpass, though which may work. It’s a webapp, essentially so you should be able to access it on your Blackberry.

What can I expect on an assessment test for PIMCO (financial service company)?

Description : What can I expect on an assessment test for PIMCO (financial service company)?

Last Answer : Basically adding rows of sums. You need baisc Excel proficiency. You will need to know how to use Functions and Formulas, also.

How do I get OpenOffice Calc to format 69% as 69% instead of 6900%?

Description : How do I get OpenOffice Calc to format 69% as 69% instead of 6900%?

Last Answer : The problem here is one of mathematics I think. 0.035 is in fact 3.5% (that is, it's 3.5 hundredths of 1. Similarly, 69 is 6900 hundredths of one. These systems (excel is the same), are trained ... make another column dividing the first by 100, then make that column into %ages. 69/100 = .69 = 69%.

What suggestions can you provide for organizing a list of worthwhile quotations in an Excel Spreadsheet?

Description : What suggestions can you provide for organizing a list of worthwhile quotations in an Excel Spreadsheet?

Last Answer : alphabetically by subject matter

I need help with a 2007 Excel spreadsheet?

Description : I need help with a 2007 Excel spreadsheet?

Last Answer : Ctl-F will open a search window in Excel.

Can you help me think through how to set up an excel spreadsheet to create some graphs?

Description : Can you help me think through how to set up an excel spreadsheet to create some graphs?

Last Answer : Excell graph tutor.