Forum Discussion
excel, cell value in entire column reduce by 4 digits
Column of 12 digit values, reduce entire column by 4 digits, in this case eliminate the 4 zeroes from 12 digit so they become 8 digit numbers
Rod0509 Depending on where are those 4 zeroes are, you could use
=LEFT(A1,8)
or
=RIGHT(A1,8)
assuming the twelve digit number is in A1 and the 4 zeroes are in the end or at the beginning.
12 digit ex 102342180000 remove the four 0000 to the right, tried =right
(A1,8) , this worked but the cell then has the formula imbeded. How to remove the formula? Note last had excel in 2008 at a job, just purchased Microsoft 365 for home, big differences. Thank you for helping.
(A1,8) , this worked but the cell then has the formula imbeded. How to remove the formula? Note last had excel in 2008 at a job, just purchased Microsoft 365 for home, big differences. Thank you for helping.
As an alternative, you could Copy the column with the LEFT formula (I presume) and Paste it onto itself As Values.
- Use "Text to Column" method from DATA tab and use Fixed Length to separate values from column.
- This worked, thankyou. I am on a learning curve and so appreciate the help.
