thinksmart12
New Member
- Joined
- Jan 14, 2016
- Messages
- 2
Hey everyone,
I am trying to create a function that will extract a number in the given string and print that number in the cell. I had this issue in the past and found the solution on these forums using either LOOKUP or VLOOKUP, but stupid me cannot find that post again.
I have data that looks like this:
<tbody>
</tbody>
What I want to first accomplish, is to put some formula and drag it down in column B, so that B gets populated with the numbers from column A. I have hundreds of rows where there is some number given in column A. I would like to drag down over the hundreds of rows and have it output the corresponding number from column A into column B.
If you look at the last row in italics, there is no number in column A. For these rows, I would like to have a formula that searches for certain keywords (in this case, the word "calorimetry") and output a number based on that. If the keyword is not present, then skip it. I can then modify this formula to search for different words and output different numbers based on that.
If anyone can help with this, that would be great! Like I said, I think the solution to this was posted in this forum before, but after extensive searching I cannot find it.
Thank you!
I am trying to create a function that will extract a number in the given string and print that number in the cell. I had this issue in the past and found the solution on these forums using either LOOKUP or VLOOKUP, but stupid me cannot find that post again.
I have data that looks like this:
A | B | |
<tbody> </tbody> | 5 | |
<tbody> </tbody> | 12 | |
<tbody> </tbody> | 10 | |
<tbody> </tbody> | 12 | |
<tbody> </tbody> | 10 | |
<tbody> </tbody> | 4 |
<tbody>
</tbody>
What I want to first accomplish, is to put some formula and drag it down in column B, so that B gets populated with the numbers from column A. I have hundreds of rows where there is some number given in column A. I would like to drag down over the hundreds of rows and have it output the corresponding number from column A into column B.
If you look at the last row in italics, there is no number in column A. For these rows, I would like to have a formula that searches for certain keywords (in this case, the word "calorimetry") and output a number based on that. If the keyword is not present, then skip it. I can then modify this formula to search for different words and output different numbers based on that.
If anyone can help with this, that would be great! Like I said, I think the solution to this was posted in this forum before, but after extensive searching I cannot find it.
Thank you!