ANmarS - Portfolio - SplitCell

Excel/VBA expert since Sep 1997 (21 years 2 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)

1018 downloads | Last updated: 1/15/2014

Screen shots (4)