Need formula for removing words from a cell.

Originally Posted by Luke Andrews

In cell B1, would i have to manually type that in? or could i work around the formula you put in C1?

Replace the B1 with your text like the below
=TRIM(SUBSTITUTE(A1,"5th dimension",""))

Hope this helps!