Find and Extract text from a cell content

[Closed]
Report
Posts
2
Registration date
Thursday December 12, 2013
Status
Member
Last seen
December 15, 2013
-
Posts
2
Registration date
Thursday December 12, 2013
Status
Member
Last seen
December 15, 2013
-
I need to search a cell for content and extract and display a portion of the cells content. How do I do this?

Here are more specifics.

lets say the cell contains the following text content "BS, CC, CE, DP6, EL13, EM, ES2, FS, GN4, HV, JN5, LG, PL, PS, RF, SI, UP4, WC, WT"

I want to find each time "EL#" shows up and display the EL#. the complication is that the the number following EL can be different in each cell, say EL1 in one cell and EL7 in the next.

How do I find cells that contain an EL and display the "EL13", as in the above example?

Your assistance is greatly appreciated

Rob

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
suppose A1 is EL13 or any number after "EL"
in B1 type this formula and see

=RIGHT(A1,LEN(A1)-2)


experiment with various entries in A1
Posts
2
Registration date
Thursday December 12, 2013
Status
Member
Last seen
December 15, 2013

"Venkat1926"
Thank you for your reply but I believe I was not clear.

In cell A1 would be the entire string
"BS, CC, CE, DP6, EL13, EM, ES2, FS, GN4, HV, JN5, LG, PL, PS, RF, SI, UP4, WC, WT"
A2 a different string, etc.

I want to find anytime EL# occurs (say in the above string EL13, or in A2 with EL5, etc.) and have the result of the formula be "EL13"