Thread: Removing Text
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rob Rob is offline
external usenet poster
 
Posts: 718
Default Removing Text

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