Add/subtract from number range in single cell

Hello,

I have a spreadsheet with a number of cells displaying various number ranges. For example, a cell might contain "33-38". Every now and then I need to reduce the range or increase it by a certain number, and both the lower and upper limits are increased/decreased the same amount. Due to the number of cells, this is quite cumbersome to do manually. Is there a way to format the range differently so that it allows for easy mass adding or subtracting? I know that I could split the range into separate cells, but this is not possible due to restrictions from the end user.

Thanks!

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Forth on the sample file,

MrShorty probably has the solution. You could also split the "33-38" into columns, manipulate them as needed with formulae, and then CONCATENATE them back together with the all important "-". Or, if the change in the limits will be variable based on another cell entry, you can modify MrShorty's example to

=CONCATENATE(LEFT("33-38",2)+$A$1,"-",RIGHT("33-38",2)+$B$1)

Where $A$1 and $B$1 are absolute references to the variable you want to change the lower and upper limits by, respectively.