We want to share an important update with our Betfair Community users.
Over the coming months, the Betfair Community platform will be winding down. The final active day for the platform will be December 21st. From December 22nd, users will no longer be able to access the platform.
Your discussions, insights, engagement, and, most importantly, feedback have helped shape the platform and guided innovation. Your feedback continues to be important to us, and we will continue to listen via our dedicated feedback channels, as well as through product testing and innovations.
To share your feedback and experience, visit: https://support.betfair.com/app/home
Chit Chat
There is currently 1 person viewing this thread.
Is 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 sequence of numbers within it. e.g. I'm looking for, say 763214 - doesn't matter if there's a decimal point within that sequence or if those numbers are contained within a larger sequence of numbers in the cell . Does that make sense?
Want to avoid using a parallell column with IF(cell=763214;1;0) type command; just want directing to the cell with the relevant sequence in it.
Any help greatly appreciated.
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 sequence of numbers within it. e.g. I'm looking for, say 763214 - doesn't matter if there's a decimal point within that sequence or if those numbers are contained within a larger sequence of numbers in the cell . Does that make sense?
Want to avoid using a parallell column with IF(cell=763214;1;0) type command; just want directing to the cell with the relevant sequence in it.
Any help greatly appreciated.
sort by:
Show
per page
Replies: 6
|
By:
ask for compound magic over on gb, he'll know
|
|
By:
maximum of 3 in a cell in most prisons ha ha
|
|
By:
http://en.allexperts.com/q/Excel-1059/2008/4/extract-numbers-text-string.htm
|
|
By:
Many thanks Rockin Horse. Have had a quick gander and I rather think I may have to stick with some sort of parallel column with an IF formula alongside each cell.
|
|
By:
can you not just use "find" option ?
|
|
By:
off top of my head its under edit - then called find/replace , just type in what you are lookign for in find box and it brings up alist of everything that contains what you are searching for
sorry havnt got excel on this laptop and i cant be arsed to turn my other one on but its somethign like that |