This is a result of the same formula:
Formula:
<ul>
<li>Hardware: Grace Pull 3-3/4 Inch</li>
<li>Style: Contemporary, Traditional</li>
<li>Finish: Brushed Satin Nickel</li>
<li>Material: Zinc Alloy</li>
<li>Collection: Asbury</li>
<li>Length: 4-7/16 in.</li>
<li>Width: 5/8 in.</li>
<li>Projection: 1-1/4 in.</li>
<li>Center-to-Center: 3-3/4 in.</li>
<li>Base Diameter: 5/8 in.</li>
</ul>
You can try this one:
Formula:
=IFERROR(REPLACE(A1,SEARCH(CHAR(32)&"?"&CHAR(32),A1)+2,1,"-"),A1)
or
Formula:
=IFERROR(REPLACE(TRIM(A2),SEARCH(" ? ",A2)+2,1,"-"),A2)
but if you have something different than space (CHAR(32) you need to know what is it.
attach example file with more data what will be more representative.
Bookmarks