To add value to the number part of a string

Closed
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
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

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
=LEFT(A1,1)&RIGHT(A1,1)+1