office help
 

This is the one time I wish I had linux.

Anyone know of a windows program or of a way in office to replace all occurrences of references with a linear addition?

For example:

I need to add +4

[1],[4],[5-9] -> [5],[8],[9-13]

Thanks.

what kind of file? i'm assuming excel. a pretty simple macro should do it.

what linux program does that?

oh is that just lines of text? Can you do VB at all?

its office word

and with linux I could use sed/awk/grep commands to parse the file.

I've never gotten down to the the VB level in word - I kinda don't have time to mess around with programming it (as simple as it is, I get side-tracked very easily); is there a simpler solution?

vim for windows has a find and replace function


EDIT: Nm that wont work

If it was excel it'd be awesome. But its a technical paper and I'm combining multiple papers with different cited sources and their numbers need to match up.

I would spit one out for you but I've only ever worked with excel, im not sure how you read text from a text file.

I can use word, sort of, but their find and replace is awkward at best and they don't have mathematical commands since everything is text based - so adding 4 is just improper and confuses the shit out of the program.