Hi 
This is the question:
in a cell: word1 word2 word3 word4 word5 etc
I want to take out of this cell the text start with SO***** (2 letters+5 digits).
This text is placed random in the cell.
Pls advs, is this possible with excel 2010 or only with VBA?
Thnks in advance,
Peter

This is the question:
in a cell: word1 word2 word3 word4 word5 etc
I want to take out of this cell the text start with SO***** (2 letters+5 digits).
This text is placed random in the cell.
Pls advs, is this possible with excel 2010 or only with VBA?
Thnks in advance,
Peter