Challenge 31 – Increment All Digits by 1

This time's challenge is a short one but it may take some time to think through.

Suppose, you have a number in cell A1. The challenge is to add 1 in all digits and come with a result.

Hence,

If A1=28, result would be 39.

If A1 = 123, result would be 123+111 = 234

If A1= 912, result would be 912+111 = 1023

If A1=1999, result would be 1999+1111 = 3110

If A1=9999, result would be 9999+1111 = 11110

You can choose to post your answer in comments section.

Note – Solution to this challenge will be published after 1 month i.e. on 05-Jan-16.