New Posts For Thread: Spreadsheet: Help wanted re.. locating numbers in a cell.https://community.betfair.com/general_betting/go/thread/view/94082/23493934/spreadsheet-help-wanted-re-locating-numbers-in-a-cellIs there a way to look/search/locate/find a specific string of numbers in a spreadsheet?Imagine you've a giant page of thousands of cells with different numbers in. I want a quick way to find any cell (or even just 1 cell) that has a specific sequencSelect a cell at the start of your dataclick on find & select(menu) Click find, type in what numerical string you wish to findMake sure values are selected and then click find next.https://community.betfair.com/general_betting/go/thread/view/94082/23493934/spreadsheet-help-wanted-re-locating-numbers-in-a-cell?post_id=419695258#419695258Select a cell at the start of your dataclick on find & select(menu) Click find, type in what numerical string you wish to findMake sure values are selected and then click find next.Tue, 05 Jan 2010 17:05:05 -0600it can be done using FIND, LEFT and CONCATENATE functions. Could you figure it out? You can easily get it by asking on mrexcel.comhttps://community.betfair.com/general_betting/go/thread/view/94082/23493934/spreadsheet-help-wanted-re-locating-numbers-in-a-cell?post_id=419695238#419695238it can be done using FIND, LEFT and CONCATENATE functions. Could you figure it out? You can easily get it by asking on mrexcel.comTue, 05 Jan 2010 14:40:54 -0600Cheers Lori - Iv'e tooled around with it and it goes some way.https://community.betfair.com/general_betting/go/thread/view/94082/23493934/spreadsheet-help-wanted-re-locating-numbers-in-a-cell?post_id=419695234#419695234Cheers Lori - Iv'e tooled around with it and it goes some way.Tue, 05 Jan 2010 13:05:39 -0600*won't do the decimal thing though, the string would have to have no decimal in it.https://community.betfair.com/general_betting/go/thread/view/94082/23493934/spreadsheet-help-wanted-re-locating-numbers-in-a-cell?post_id=419695230#419695230*won't do the decimal thing though, the string would have to have no decimal in it.Tue, 05 Jan 2010 12:59:55 -0600yep, ctrl-f does what you need therehttps://community.betfair.com/general_betting/go/thread/view/94082/23493934/spreadsheet-help-wanted-re-locating-numbers-in-a-cell?post_id=419695226#419695226yep, ctrl-f does what you need thereTue, 05 Jan 2010 12:59:37 -0600It makes sense... I think it still works and you can click "next" to scroll through them. I'll give it a quick gohttps://community.betfair.com/general_betting/go/thread/view/94082/23493934/spreadsheet-help-wanted-re-locating-numbers-in-a-cell?post_id=419695222#419695222It makes sense... I think it still works and you can click "next" to scroll through them. I'll give it a quick goTue, 05 Jan 2010 12:59:00 -0600Thanks for your suggestion, but that will (I think) only find a cell that contains solely those numbers enterd in the "find" box. So, say, if I'm looking for anywhere where the sequence 564676 occurs, CTRL-F will only take me to that cell if they arhttps://community.betfair.com/general_betting/go/thread/view/94082/23493934/spreadsheet-help-wanted-re-locating-numbers-in-a-cell?post_id=419695218#419695218Thanks for your suggestion, but that will (I think) only find a cell that contains solely those numbers enterd in the "find" box. So, say, if I'm looking for anywhere where the sequence 564676 occurs, CTRL-F will only take me to that cell if they arTue, 05 Jan 2010 12:55:22 -0600Probably not what you mean, but just in case, have you used ctrl-f on the keyboard?https://community.betfair.com/general_betting/go/thread/view/94082/23493934/spreadsheet-help-wanted-re-locating-numbers-in-a-cell?post_id=419695214#419695214Probably not what you mean, but just in case, have you used ctrl-f on the keyboard?Tue, 05 Jan 2010 12:46:40 -0600Is there a way to look/search/locate/find a specific string of numbers in a spreadsheet?Imagine you've a giant page of thousands of cells with different numbers in. I want a quick way to find any cell (or even just 1 cell) that has a specific sequenchttps://community.betfair.com/general_betting/go/thread/view/94082/23493934/spreadsheet-help-wanted-re-locating-numbers-in-a-cell?post_id=419695210#419695210Is there a way to look/search/locate/find a specific string of numbers in a spreadsheet?Imagine you've a giant page of thousands of cells with different numbers in. I want a quick way to find any cell (or even just 1 cell) that has a specific sequencTue, 05 Jan 2010 12:44:09 -0600