Digits on both sides

[MrsFrankieH]

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._{^{<strike>
</strike>}}



I hope you can help me.
Thank you!!! J

 

[MrsFrankieH]

Hi Rick!!

Oh no, it only looked complicated to my untrained eyes. After I did it, it became crystal clear. I WILL use this formula as well. You wouldn't believe how much I learn about formulas just by you guys writing them. I learn the mechanics of them. Thank you again. I'll be posting a new one tomorrow, I hope to catch you on. Lots of appreciation and gratitude!!!

Frankieann

 

[Rick Rothstein]

Hi Rick!!

Oh no, it only looked complicated to my untrained eyes. After I did it, it became crystal clear. I WILL use this formula as well.

Did you see what I posted in Message #9 yet?

 

[MrIfOnly]

Hello MrIfOnly!!

I tried it and it works!! I even put different numbers in including 41 and 1 and they worked like a charm!! Thank you also for your time and expertise!!! I made pie and if I could just give you two awesome guys a slice I would. It's amazing!!! Thanks again and have a wonderful night!!! I really appreciate it!!

Frankieann.

*BIG IDEA*: Develop method for transporting custard pie through e-mail. I'll be working on this...look for me on Shark Tank!

CJ