CREATE MACRO

  1. Type or paste list of text
  2. Click record icon in toolbar
  3. Hit Ctrl+H
  4. Enter “^” in “Find what” field
  5. Enter “|” in “Replace with” field
  6. Click “Regular expression”
  7. Click “Replace All”
  8. Hit Ctrl+Home
  9. Hit Delete
  10. Type “{“
  11. Hit Ctrl+End
  12. Type “}”
  13. Hit Ctrl+H
  14. Enter “\r\n” in “Find what” field
  15. Enter space in “Replace with” field
  16. Click “Extended”
  17. Click “Replace All”
  18. Enter ” |” in “Find what” field
  19. Enter space in “Replace with” field
  20. Click “Replace All”
  21. Click stop record icon in toolbar
  22. Click Macro >> Save Current Recorded Macro…
  23. Enter a name
  24. Click “OK”

RUN MACRO

  1. Type or paste list of text
  2. Click Macro >> *name of macro*

Resources