Remove Language

[jhow77]

I have two languages in one cell. How do I remove one of the languages out of the cell or delete one of the languages?? I want to keep English in the cell.

[bmouse]

Perhaps not the most innovative way, but use Find and Replace. Copy the foreign language fragments and paste them in the tool, then replace them with blanks.

[jhow77]

Did not even think of that and yea that worked perfectly.

Thank you!!

[huuthang_bd]

Try this array formula

Please Login or Register  to view this content.

[Speshul]

Solved but I was working on this array formula and thought I'd post anyway...it...almost works?

Would work if there were no Spaces or slashes ^^

=LEFT(A2,SUM(IFERROR(--((CODE(MID(A2,ROW($A$1:$A$200),LEN(A2))))>65),"")))