Extracting string from a cell

marwinrj

hi all,



would love some help here for this--

I have a column that contain these strings in a

cell:

"relates to ABC-25277, relates to AF-4329"

"is caused by ABC-33334, relates to ABC-33362, relates to AF-10303"



I want to extract the "ABC-25277" from the cells and populate into a new column.



 

Sumbunnie

Is the "relates to ABC-25277, relates to AF-4329" all one string in one cell?  And do you want to return just the ABC-25277 or both ABC-25277 and AF-4329?  

If you want to return both codes you could try the SUBSTITUTE formula to remove the "relates to " text:

=SUBSTITUTE([ColumnName]@row, "relates to ", "")

If you only want the ABC code then maybe something like

=MID([ColumnName]@row, 12, 9)

I'd have to think about the one with 3 codes and the "is caused by" text.. You could extract each code using a MID formula into some "helper columns", concatenate them into your new column, then hide the helper columns.  Clunky but would do the job.

Hope that helps!