Quote:
Originally Posted by Spencer101
=RIGHT(cell,6)
Change cell for the relevant cell reference. For example =RIGHT(A1,6)
|
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?