View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
[email protected] pfsardella@yahoo.com is offline
external usenet poster
 
Posts: 96
Default LEFT Function in Macro

activecell.Value=left(activecell.Value,4)

HTH
Paul
--------------------------------------------------------------------------------------------------------------
Be advised to back up your WorkBook before attempting to make changes.
--------------------------------------------------------------------------------------------------------------