Filter column for content longer than 12 characters?

RobertHuskey 

Hello,

You should be able to use the "=RIGHT()" Function to accomplish the task.

The syntax for it is =RIGHT(A1,12)

• A1 is just the cell that you want to find contents the "right"

So if your serial number is for example "00123456789XC6", and you want the last 12 characters. Then using the above formula will return "123456789XC6"

You would have to put the formula in a separate column, but then after it calculates you can copy over the values and paste as text in the correct column if desired. Additionally, this formula would not mess up any of the other cells were the numbers are less than 12 as it would include everything at that point.

Please let me know if this doesn't help or if you have additional questions.

Regards,

-Jack B.