The Search formula
Definition
The search formula will search for a specified field or character in the selected cell.
The makeup of the formula
It only consists of two fields
- First you have to specify what text must be search for
- Then you must specify in what cell must be searched for
Example
Nr |
Text |
Formula |
Result |
1 |
The hills have eyes |
=SEARCH(" ",B2) |
4 |
2 |
Excel is easy |
=SEARCH(" ",B3) |
6 |
3 |
division 3000 |
=SEARCH(" ",B4) |
9 |
4 |
centre 2344 |
=SEARCH(" ",B5) |
7 |
5 |
The hills have eyes |
=REPLACE(B6,SEARCH(" ",B6),1,"") |
Thehills have eyes |
For the first 4 we search for a space in the cells. The result will be the place where this space exists.
We can use the search formula very effectively with the replace formula like in 5. Only put the search formula in the second field of the replace formula.
The formula function bar
Things you can do with the search formula
- Find the starting point of text in a cell...contact us for more info
- Use in combination with the replace formula to find the start number of where to replace...contact us for more info
<-----Back to index
Next topic----->
