Selecting text from a string 1

[rookery]

Is there anyway to select text from a string other than using the Mid, Left or Right functions? For example could you do something like the following:

str1 = "This is a test"
str2 = "test"

str3 = str1 - str2

str3 = "This is a"

I know this is a simplistic example but you get the general idea. Are there any suitable methods?

 

[MarrowGenx]

Have you tried the split function. If not, check out this page:

http://www.j-walk.com/ss/excel/tips/tip93.htm

It shows some good examples of how this function works. Hope this helps.

Marrow

 

[rookery]

Thanks for your response Marrow. Wasn't aware of this function before but is very interesting.