DiceCoDude
New Member
- Joined
- Oct 1, 2021
- Messages
- 4
- Office Version
- 365
- Platform
- Windows
I'm trying what I suspect is far easier than I'm making it.
I'm attempting to decrement the following cell by 4:
interface g1/0/5
the new text will be:
interface g1/0/1
I've tried a few ways with only slight success but I think this one is on the right track:
=REPLACE(A2, 16, 1, "?" ) - The question mark shows where I'm lost. I want to replace position 16 ("5" in this case) with the sum of position 16 - 4. Then I can drag the formula down the rest of my spreadsheet. This is a network switch configuration so I have to repeat this replace formula 240 times for each data closet, so... 48,000 times? I'm trying to find a way to save many hours of tedious work. MUCH appreciated.
I'm attempting to decrement the following cell by 4:
interface g1/0/5
the new text will be:
interface g1/0/1
I've tried a few ways with only slight success but I think this one is on the right track:
=REPLACE(A2, 16, 1, "?" ) - The question mark shows where I'm lost. I want to replace position 16 ("5" in this case) with the sum of position 16 - 4. Then I can drag the formula down the rest of my spreadsheet. This is a network switch configuration so I have to repeat this replace formula 240 times for each data closet, so... 48,000 times? I'm trying to find a way to save many hours of tedious work. MUCH appreciated.