Array function. To use this array function, select a range of cells
(e.g. an area of 3 by 5 cells) and type the formula in the formula bar.
Then press Ctrl+Shift+Enter.
Description: Splits the text into separate fields which are
shown in individual cells. By default SplitText will split the text at
spaces. You can give another delimiting charater in the Delimiter
parameter. By default SplitText will output all fields that it could split
but you can limit the number of fields with the Limit parameter. By
default SplitText will do a text comparison but you can set it to binary compare (0)
using the Compare option
Text : String to split Delimiter : Optional.
String that delimits the fields (defaults to a space) Limit: Optional.
Sets a maximum to the number of fields to output Compare: Optional. Sets the compare mode to binary (0) or text (1)
Example: Select cells
A1:E1 Type the following formula and press
=SplitText("This is a great
E 1 this is
examples: =SplitText("A|B|C|D|E|F|G" ,
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.