Cupid Stunt
New Member
- Joined
- Sep 28, 2014
- Messages
- 16
Hi,
Please could someone help
I need a formula that will return true if start of a cell contains any number with 2 decimal places then a space then a hyphen. the cell could also contain any other text after this.
i.e. "201.11 -pjkdlsg" would return True
but "sdjklg 201.11 -ppsdfg" would return False
The 201.11 - must be at the start of the cell.
I am currently using IF(COUNT(SEARCH("?.?? -*",H3))>0,"false","true") but this searches the whole cell and returns true is 201.11 - is anywhere in the cell not just the start.
Please could someone help
I need a formula that will return true if start of a cell contains any number with 2 decimal places then a space then a hyphen. the cell could also contain any other text after this.
i.e. "201.11 -pjkdlsg" would return True
but "sdjklg 201.11 -ppsdfg" would return False
The 201.11 - must be at the start of the cell.
I am currently using IF(COUNT(SEARCH("?.?? -*",H3))>0,"false","true") but this searches the whole cell and returns true is 201.11 - is anywhere in the cell not just the start.