alteryx adding number

[ryanzhang487]

Hi community, I have a column like this showing in the picture, i would want a formula to add 1 to the right side of the " - " (eg, 5-9 will be 5-10, 1-2 will be 1-3),

how do I do that please?

Thank you 

[binuacs · Accepted solution]

@ryanzhang487 One way of doing this with the formula tool

SubString([Temp],0,FindString([Temp], '-'))+'-'+toString(toNumber(SubString([Temp],FindString([Temp], '-')+1,Length([Temp])))+1)