Most valuable professional
  • Hot Topics

Excel Find specific text

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.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel