I download data from our payroll and one of the cells contains the employee name and payroll number in the following format:
Smith, Alan [10]
Taylor, Annabel [184]
Sutton, Doug [7453]
Using an Excel formula, how do I extract the values between the square brackets?
Thanks for any help
Smith, Alan [10]
Taylor, Annabel [184]
Sutton, Doug [7453]
Using an Excel formula, how do I extract the values between the square brackets?
Thanks for any help