View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
rojobrown rojobrown is offline
external usenet poster
 
Posts: 22
Default Remove Last x Character(s) in Selected Cells

I do. Would you be able to help me?
--
Thanks a bunch!
rojobrown


"Barb Reinhardt" wrote:

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