Thread: Remove Last x Character(s) in Selected Cells
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
  
Posts: 3,355
Default Remove Last x Character(s) in Selected Cells
Here's an equation to do it in helper column

=left(A1,len(A1)-2)

Do you need it in a macro?

"rojobrown" wrote:

How do you remove the last two digits in a cell using a macro?

--
Thanks a bunch!
rojobrown
Reply With QuoteReply With Quote