Excellence
Prerequisites
- Microsoft® Windows®
- Microsoft® Excel® 2010 or later
- Compliance in the Cloud's Excellence add-in
SEGMENT
The SEGMENT function will split a text value at any occurance of a delimiting character, and then return the segment number specifed.
SEGMENT(text,delimiter,segment)
- text
- The original source text value.
- delimiter
- A text value containing all of the characters used to split the text value.
- segment
- A numeric value indicating the segment required.
None
If the system is unable to calculate the result, an empty value is returned.
Successive delimiting characters in the original text value, does not produce an empty segment.
=SEGMENT("Movies (released this week) include","()",3) will output result " include".
Note: The resulting values may include space characters at the beginning or the end of the result.