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
