I was wondering if there was an excel formula that would return a value that it is greater than the previous value by 1. The previous value can…

I was wondering if there was an excel formula that would return a value that it is greater than the previous value by 1. The previous value can contain a mix of numbers and words. For example, Person 1 becomes Person 2 in the next cell.

"Order a similar paper and get 15% discount on your first order with us
Use the following coupon
"FIRST15"

Order Now