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 :
Quick links:
help index

String - Words

= 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.

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.

Select the cells A1 to D1. Enter the following formula and press Ctrl+Shift+Enter
=Words("hello this is great!")


          A          B          C          D
1    hello      this        is          great!