Most valuable professional
  • Hot Topics

Excel Digits on both sides

Hello fellow Members! My operating system is Windows 10 and us Office 10. I?m trying to put the digits that comes before and after the target digit on the left. For example: The target digit on the left is 9, so it will produce 8 and 10 on the right. The range of the numbers are from 1 to 41. Note: If the number on the left is ?1?, the numbers (on the right) will be 41 and 2. If the number on the left is ?41?, the numbers (on the right) will be 40 and 1. I hope you can help me. Thank you!!! J

This question generated 12 answers. To proceed to the answers, click here.

This thread is current as of March 18, 2017.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel