SplitCell

Split text into cells

Free

Download
Quickly and easily split a cell with large text into cells with a word each.
This was part of larget macro, mainly used to create TagCloud

Published:
Mar 2012
File size:
16.8KB
Downloads:
1,469 (Since Mar 2012)
Internal ID:
77384 (type2)
1 File Tools
Quick tools. Tools that are in 1 file
VBA - Excel
Macros, or Visual Basic for Application tool
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. Paste the article in any cell in the sheet
  2. Select that cell
  3. Click on (Split)
    • You have to select the cell you want to split before clicking on (Split)
  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

SplitCell.zip
16.8KB

1,469 Downloads