Hi, I'm trying to get the last 4 digits of 800 numbers into a new column. All numbers start in cell A1 and go down the column. The number range in size from 9 digits down to 4 digits. I used the =RIGHT formula to move them to column B and that worked great, but now I want to be able to delete the old numbers and just be left with the 4 digits, and when I delete column A all the data I moved to column B disappears as well. Is there a way to change the new data so it doesn't relate to the old data?
Thu, 07/16/2015 - 06:22#1
Move partial number from A1 to B1 then delete A1