Hello,
Is it possible to remove a certain number of characters from multiple cells.
For example, I have 800 rows, each with a 12 digit number in, but I only need the first 4 digits.
I want to remove the other 8 digits from all the cells and all the numbers are different!
Is this possible or am i in for a long night of manual work.......?
Cheers
Ian
Is it possible to remove a certain number of characters from multiple cells.
For example, I have 800 rows, each with a 12 digit number in, but I only need the first 4 digits.
I want to remove the other 8 digits from all the cells and all the numbers are different!
Is this possible or am i in for a long night of manual work.......?
Cheers
Ian