To do a dump, I'd say that it depends on which program you are using. With Hexecute, for instance, you'll have to input the starting address and the text length in hex, so you'll have to calculate it using this formula: end address - start address = length (yeah, this part is pure Math; if you're not good at calculating hex yet, the Windows calculator is good enough. To calculate hex with the Windows calculator, click on View>Programmer, and then switch from Dec to Hex). Some dumpers are simpler, like romjuice, but it's a command-line tool (it's still easy, you'll have to input a simple command line to dump everything). To open it with Windows Vista or Windows 7, open cmd.exe, and then drag and drop the tool inside the cmd window, and press Enter.
The command line for romjuice: "romjuice <rom.bin> <table.tbl> <start address> <end address> <output.txt>" (without the quotes and brackets)
For example: romjuice ff9.bin ff9.tbl 75da0 76387 ff9dump.txt
IIRC, the files must be in the same folder (at least that's how it worked for me).
To edit the text, I'd recommend using Notepad++, especially if you're translating a game from Japanese to English. Do not use Notepad, Notepad++ is superior.
To re-insert the text (with Hexecute), you'll have to input the starting address of the text and the table used to dump that text. But be careful, re-inserting text isn't as easy as you might think. You have to find a way to, like, memorize how much of the text you have changed, or you'll end up overwriting the data located right after the text block, ruining the ROM for good. If that happens, be sure to have backups, and try again.
Also, some hex editors don't have the insert text option, like Windhex, so you'll have to use Atlas to insert them (I haven't learned how to use it yet, but there must be a tutorial somewhere in the internet, maybe here at RHDN). Windhex (more commonly used for SNES and GBA games) can dump text, but it can't insert them. Well, I guess that's it.