ANmarS - Portfolio - SplitCell

Excel/VBA expert since Sep 1997 (20 years 10 months)

We are moving ...

We are moving to another location, better, faster and more resources .... check it out ANmar.Systems

SplitCell    Added: 3/27/2012 | Created: 3/27/2012   

Excel macro that split a cell into its words...
In another word, generates unique wordlist from an article in cell into the column below, sorted out alphabitically
You need to:

  1. 1- Paste the article in any cell in the sheet
  2. 2- Select that cell
  3. 3- Click on (Split)
    • a. You have to select the cell you want to split before clicking on (Split)
  4. 4- What you will see is that the article has been split into single cells with a word per cell, then sorted, then removed duplicates

This file is provided as is, for any further changes or modifications, please contact me

Download (16.8 KB)

1009 downloads | Last updated: 1/15/2014

Screen shots (4)