spill-the-beans
Board Regular
- Joined
- Feb 7, 2013
- Messages
- 52
Hi
Is it possible to create a formula that will count the number of spaces in a cell that occur before a specific character?
So if the contents of A1 was: "The quick fox (jumped/leaped) over"
Then B1 would read 3, because there is are 3 spaces before the open bracket, and any spaces after that open bracket are not included in the count.
Any help would be really great!
Is it possible to create a formula that will count the number of spaces in a cell that occur before a specific character?
So if the contents of A1 was: "The quick fox (jumped/leaped) over"
Then B1 would read 3, because there is are 3 spaces before the open bracket, and any spaces after that open bracket are not included in the count.
Any help would be really great!