Thread: how to delete last X number of characters in a cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
  
Posts: 8,856
Default how to delete last X number of characters in a cell
If you want to get rid of the rightmost 4 characters from cell A1, for
example, use this:

=LEFT(A1,LEN(A1)-4)

Hope this helps.

Pete

On Jul 25, 4:05 pm, "
wrote:
using XL 2003.

Thanks!!

...Lisa


Reply With QuoteReply With Quote