Thread: Reading the last for characters of a data.
View Single Post
  #2   Report Post  
Spencer101 Spencer101 is offline
Senior Member
  
Posts: 663
Default
Quote:
Originally Posted by DamienPham View Post
Hello. I have a list of values in a data that has 16 characters of numbers and letters (ie. 01V4245608099269). The only numbers/letters I need are the last 6 of the list. How would I create a formula that reads only the last 6?
=RIGHT(cell,6)

Change cell for the relevant cell reference. For example =RIGHT(A1,6)
Reply With QuoteReply With Quote