So I found a formula in this link that solves 75% of my formatting problems in salesforce (https://developer.salesforce.com/forums/ForumsMain?id=906F0000000927nIAA)

The problem is it's limited to the first three set of text queries in a field (e.g. John Deere Green but a fourth word like tractors wouldn't be impacted). I'm trying to figure out how to expand it past three words. Any help? The biggest impact this would have is in the address field (4242 John Wayne street). It'd be great to capitalize the S of street in that field.

So I found a formula in this link that solves 75% of my formatting problems in salesforce (https://developer.salesforce.com/forums/ForumsMain?id=906F0000000927nIAA)

The problem is it's limited to the first three set of text queries in a field (e.g. John Deere Green but a fourth word like tractors wouldn't be impacted). I'm trying to figure out how to expand it past three words. Any help? The biggest impact this would have is in the address field (4242 John Wayne street). It'd be great to capitalize the S of street in that field.