Increment text value by one in a formula

[brauhartc]

If I have a text string such as WDR1034 in cell B6, then the formula =B6 will return the result WDR1034 <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
Is there an expression that will return WDR1035 ?? In other words, my original text string incremented by 1 ??

I know how to increment manually but I want to build the incrementation into an IF statement

=IF(C7=0, B6(+1), B6)

The (+1) part of the expression obviously doesn't work and that is where I am stuck.

What do I enter here to get a result of WDR1035<o> ??</o>

 

[BeingYogi]

May Be

IF(C7=0,CONCATENATE(LEFT(B6,3),RIGHT(B6,LEN(B6)-3)+1),B6)

 

[brauhartc]

Dear Being Yogi,

You champion! Your formula works.

When you come to Perth I will buy you a beer!! I will also learn more about CONCATENATE

Kind regards
Carl

 

[BeingYogi]

Hey Thanx, but I don't booze