Excel Extracting Specific Words From 1 Column to Another
<p>I am trying to parse column A to get specific names to populate column B. As some of the information is automatically generated, I used =TRIM to pull the words that follow after certain characters to get the desired result. </p>

<p>Ex: "(DROP FAIL) Acer" in column A shows up as just "Acer" in column B.</p>

<p>The problem is the data that doesn't follow this standard:</p>

<p>Ex: "DROP FAIL - Acer" displays as "#VALUE!" in column B.</p>

<p>There are a lot of names that have this issue. Is there anyway around this?</p>