Quote Originally Posted by hegisin
Hi Guys,

I have a database of textstrings where a lot of them start with some numbers or lower case letters. I want to eliminate them as all important information always start with the first capital letter of a text string. How can I find out what is the position of the first capital letter, so that I can delete all characters in front of them?

Any suggestion?

Cheers,
hegisin
Try this, if your text string is in A2, then in B1:AA1, put the letters of the alphabet in CAPS
Then in B2 put this
=IF(ISERROR(FIND(B$1,$A2,1)),"",FIND(B$1,$A2,1)) and drag across to AA2
Then in AB2 put this
=MIN(B2:AA2)
Then in AC2 put this
=MID(A2,AB2,100), if the text is long that 100 characters, adjust to suit.