To add value to the number part of a string

Closed
Ahmad - Nov 22, 2009 at 03:30 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 22, 2009 at 10:13 PM
Hello,
I need an excel formula to add 1 to the number part of "Q3". The formula should result in giving me "Q4". pretend that I have "Q3" in cell A1 and I want the formula to be used in cell A2. thanks
Related:

1 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Nov 22, 2009 at 10:13 PM
=LEFT(A1,1)&RIGHT(A1,1)+1
0