Linker IT Software
Order Home
menubar-top-links menubar-top-rechts
SQL*XL: Database to Excel bridge ExcelLock: Lock and secure your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe
Home Products litLIB Help String functions

Buy now

Download now

LITlib - Excel Power Functions Pack
 
Add-in for Excel that adds additional cell functions to Excel.

litLIB Help - WorksheetName function
litLIB Help
Product pages :
litLIB
Quick links:
help index
forums

String - Words

Syntax:
= Words(Text)

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!")

Result:

          A          B          C          D
1    hello      this        is          great!


 

litLIB