Array formula. To use this function select a range of cells (e.g. 1
column and 5 rows). Then enter the formula and press Ctrl+Shift+Enter. The
results will show up in the cells.
Description: Parses in string into words and shows the
resulting words each in a new cell. This function is ideal to cast a
plain text table into an Excel table.
Text: String with words to separate.
Example: Select the cells A1 to D1.
Enter the following formula and press Ctrl+Shift+Enter =Words("hello this is great!")
D 1 hello
Copyright (C) 1995-2014 Linker IT
Software BV. All Rights Reserved. Oracle is a registered trademark of
Oracle corporation. Excel and Office are registered trademarks of
Microsoft corporation. Other names appearing on the site may be trademarks
of their respective owners. Software,
files, documents, articles and other material are provided
"as is" and without warranties as to performance or mechantability or
any other warranties whether expressed or implied. No
warranty of fitness for a particular purpose is offered.