MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Find text in an Excel cell


Posted by Kenn Cruse on June 30, 2001 8:54 AM

I am trying to write a routine that will search through a range of cells in a column for specific text contained in that cell. A cell may have the following characters in one cell; AGAP!7#E500 ALB!4.1#E500 ALKP!77#E500.

I want to extract the #E500 and write it to another cell on the same row as follows:


Posted by Kenn Cruse on June 30, 2001 8:56 AM

I want to extract the #E500 and write it to another cell on the same row.


Posted by Aladin Akyurek on June 30, 2001 9:18 AM

Kenn,

If #E500 is always the last part of a string, use

=RIGHT(A1,5)

If you rather want the string from which #E500 has been strpped, then use

=LEFT(A1,LEN(A1)-5)

Copy down whichever formula you need as far as needed.

Aladin