ctrlaltdel
Board Regular
- Joined
- Dec 1, 2002
- Messages
- 60
Does someone know of either a formula or VBA code to locate and give the position of the nth occurence of a character in a text string in a cell?
For example:
If cell C5 = "Colorado - 1995 - Math - State Deptartment"
How might I get the character position of the 3rd hyphen without doing a nested formula?
Thanks for any help on this.
For example:
If cell C5 = "Colorado - 1995 - Math - State Deptartment"
How might I get the character position of the 3rd hyphen without doing a nested formula?
Thanks for any help on this.