To add value to the number part of a string

Closed
Ahmad - 22 Nov 2009 à 03:30
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 22 Nov 2009 à 22:13
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 response

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