re: note 2

The actual is number is 23 characters. I gave 10 in my example 'cause it's a nice round number. True, my sample data does not show this, that's why I said...

"Now the one thing that is consistent (my example doesn't show this) is that the company names will always start at the 15th character from the left and end at the 25th character from the left..."

If a company name has more than 23 characters, the name would get cut off (I have no control over the data that is given to me).

Thank you for your example. I think that it is exactly what I needed. I will also look at pos() as I am unfamiliar with it.