In Textpad I have opened a TXT that was exported from a spread sheet. It's a very, very long list of names formatted as "Last, First".
How can I very quickly do a Find-and-Replace to make them all "First Last"?
Thank you!
In Textpad I have opened a TXT that was exported from a spread sheet. It's a very, very long list of names formatted as "Last, First".
How can I very quickly do a Find-and-Replace to make them all "First Last"?
Thank you!
Copyright © 2021 Jogjafile Inc.
If delimited properly, with line breaks between names, and no additional commas are in the Last or First names, then you should be able to import this into an excel file. From there you can edit the file with much greater ease.
Steps, open text file with Microsoft Excel, (use comma delimited), saved it as an excel file, made a third column with the following formula
Fill this down to replicate this formula
Lastly, delete Column B and C, and resave the file as a text file.