Specs: 3200 sep. hours, always stored inside, auto steer ready, excellent tires, pro drive unit, has power cast tail board for straw chopping, has 28' unloading auger, a/c works, used for wheat harvest this year. Does not sell with GPS unit-i.e. screen & globe I am trying to make column C return the "Seperator hours" from cells in column B. Column B has hundreds of cells with specs of machines and they all have the hours listed before the letters "sep" but sometimes the text "sep" has a capital S and sometimes it does not. The hours are also not always in the same place in the cell as shown above in the example of what two of the cells in the "B" column look like. I also need the result to be in number form so that I can use it in number formulas after the fact |
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Finding numbers in cell with text
- Thread starter Lancer7
- Start date
Yep!! I think that's worked. I used the first one you sent with the substitute and just finished looking over the sheet better and I haven't found any errors whatsoever. So don't think I will even try the last one you sent unless I run into issues down the road. Thank you!
Upvote
0
Excel Facts
Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
