Apr 15 2020 11:55 AM
We are working a spreadsheet with @30K rows of data. We have an issue that we cannot process a certain column if more than 12 Characters.
1st task is to filter this column for any cells longer than 12 characters.
2nd task if even possible, is to remove characters from the front end of content down to 12 characters.
*These are Serial numbers, so the more important data are the last 4-6 characters and cannot be lost.
Thoughts/help?
Thank you.
Apr 15 2020 12:52 PM
Hello,
You should be able to use the "=RIGHT()" Function to accomplish the task.
The syntax for it is =RIGHT(A1,12)
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.
Apr 15 2020 02:14 PM
@Jack_Bumgarner Thank you. Adding the column, using the formula, etc worked and task is completed.