View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bj bj is offline
external usenet poster
 
Posts: 1,397
Default Keep specified number of characters at end of cell?

if they are text try
=right(A1,6)


"Kevin" wrote:

I am trying to keep 6 characters at the end of a random length of characters
in a cell. I know how to delete a specific number of characters etc.