Hello All I need to pull a specific word from a string of text in a cell and have that word shown in an adjacant cell. For example A1 will contain the text "Smith Sun Alliance Pension Fund" I need B2 to show "Pension". I cannot use any filtering or text to columns as the word Pension can be anywhere within the text in A1 and I have thousands of entries. So I need a function. Help would be as always greatly appreciated. Thanks Matt
This question generated 32 answers. To proceed to the answers, click here.
This thread is current as of May 16, 2004.