Removing Text

[Rob]

Hi Everyone,

Problem - Im trying to remove the last two characters (Text) from each cell.

Example:
(A1)Expense Account
(A2)Robert Smith

Result Deisred:
(A1) Expense Accou
(A2) Robert Smi

Any help would be greatly appreciated.

Thanks!
Rob

 

[Gary''s Student]

=LEFT(A1,LEN(A1)-2)
this uses an extra cell to hold the formula