Thread: Reading the last for characters of a data.
View Single Post
  #1   Report Post  
Spencer101 Spencer101 is offline
Senior Member
  
Posts: 663
Default
Quote:
Originally Posted by DamienPham View Post
Thanks! I was wondering if you could help me with something else too...
So in Column A, I have a list of numbers/letters (ie. 01V4245608099269), I want Column B to read the last 6 characters of Column A and if the number is 256, Column B should say Type1. If the number is 786, Column B should say Type2. Is this possible? How would I do that?
I dont understand how the last 6 characters would be a 3 digit number. Could you explain a little more?
Reply With QuoteReply With Quote