text question, joining text files in columns?

Factual Questions
1

i’ve got two lists of text, one a set of directorys for charachters in a game
another the display name for the charachter in the directory is there any way i can join these files in aN editable format to display charachter -directory w\o having to maually edit it into one text file or another?

ie

list 1
001 bob wilson ex
002 falcon
003 o illusionista
004 saizo hattori
005 mexican typhoon
006 bigbear

list 2
!bob_ex
!falcon
!Ilu
!saizo
!so_mexican
00bigbear
turned into:

001 bob wilson ex !bob_ex
002 falcon !falcon
003 o illusionista !Ilu
004 saizo hattori !saizo
005 mexican typhoon !so_mexican
006 bigbear 00bigbear

(but with space between charachter and directory name, the board seems to edit out the extra spacing)
i dont exaCtly want to do this manually as theres near 600 directories to sort out… help please

2

I would import both files into separate Excel sheets. Then copy one column and paste it into the other sheet. Then use the concatenate function to create a third column. You can then export the values of the third column back to a text file if you wish.

3

If you do not have access to Excel, many text editors (more advanced than Notepad) have a column editing feature. Off the top of my head, I know that the late, lamented Crimson Editor does.

4

thanks. that crimson editor does EVERYTHING i need, never would have found it w/o help.

5

You don’t really even need Excel to do this. Just create a table in Word with multiple columns. Then copy and paste your contents into the different columns of the table. No need to retype anything.

6

FWIW the Semware editor does column editing too, and it’s great.