+1 to character within a string

[icetray]

If...
A1 = "20110501"
A2 = "20110502"
A3 = "20110503" etc...

and I want...
B1 = "20110601"
B2 = "20110602"
B3 = "20110603" etc...

Basically, I want to +1 to the 6th character from the left, how could I do this?

Thanks Mr. Excel Boards!

 

[Jonmo1]

Perhaps

=A1+100

 

[VoG]

Try

=(LEFT(A1,5)&MID(A1,6,1)+1&RIGHT(A1,2))+0

 

[SteveO59L]

Are your entries always 8 characters ?

 

[icetray]

Nope they are not always 8 characters.

I ended up using the LEFT, MID, RIGHT functions, and it worked perfectly.

Thanks guys!

"=(LEFT(B5,79)&MID(B5,80,1)+1&RIGHT(B5,6))"

 

[Scott Huish]

=REPLACE(A1,6,1,MID(A1,6,1)+1)

Excel Workbook
	A	B
1	20110501	20110601
2	20110501111	20110601111
PortlandExport

 

[Scott Huish]

The solution you used incremented the 80th position, not the 6th.

In that case:
=REPLACE(A1,80,1,MID(A1,80,1)+1)

 

[icetray]

Ya, I was just posting that for simplicity. I had a massive string that I had to manipulate.

Thanks anyways!
This forums is great!