Split Words in the comment text

by

This looks pretty straightforward. Just turn on the Macro Recorder, select the cells of interest, click Data > Text to Columns, and follow the prompts. Turn off the Macro Recorder when done. That’s it.

More Related Contents:

  1. Get list of sub-directories in VBA
  2. Sending HTTP requests with VBA from Word
  3. How to insert text into Outlook email editor using VBA
  4. Getting the headings from a Word document
  5. What is behind this difference in parentheses effect in VBA?
  6. Speed up multiple replacement
  7. Repeating Microsoft Word VBA until no search results found
  8. Macro to update all fields in a word document
  9. To find and replace a text in the whole document in MS Word 2010 (including tables)
  10. How do I get the old value of a changed cell in Excel VBA?
  11. For Each loop: Some items get skipped when looping through Outlook mailbox to delete items
  12. Use of symbol # (hash) in VBA Macro
  13. Excel VBA: Can’t get a match, error “Unable to get the Match property of the WorksheetFunction class”
  14. Excel VBA looping through multiple worksheets
  15. When one should use Set [e.g for SpecialCells return value]?
  16. Excel: macro to export worksheet as CSV file without leaving my current Excel sheet
  17. Is there a faster CountIF
  18. Distinction between using .text and .value in VBA Access
  19. How to add data validation to a cell using VBA
  20. VBA – Convert string to UNICODE
  21. How to break long string to multiple lines
  22. How to loop through all controls in a form, including controls in a subform – Access 2007
  23. How to copy a chart from Excel to PowerPoint?
  24. FileDialog doesn’t work
  25. How to refer to Excel objects in Access VBA?
  26. Can Advanced Filter criteria be in the VBA rather than a range?
  27. Excel Useform: How to hide application but have icon in the taskbar
  28. Reading Web Pages using Excel VBA
  29. Read and write from/to registry in VBA
  30. Unable to read data from a CSV using ADO due to the driver thinking I am working with integers/number and showing nulls instead of text

Leave a Comment