Hello all,
I sort of know how to use LEFT and LEN but not in this case.
In this particular column (A), data always appears in this format with a number on the left and the number in brackets on the right. The numbers can be either 1 or 2 digit. So I just need to remove any digits to the left of...