Documentation/How Tos/Calc: MID function
From Apache OpenOffice Wiki
<
Documentation
|
How Tos
Jump to:
navigation
,
search
CALC FUNCTIONS
Text Functions
FUNCTIONS
Base
Char
Clean
Code
Concatenate
Dollar
Exact
Find
Fixed
Left
Len
Lower
Mid
Proper
Replace
Rept
Right
Search
Substitute
T
Text
Trim
Upper
Value
< Previous Page
Next Page >
Contents
1
MID
1.1
Syntax:
1.2
Example:
MID
Returns text from the middle of a text string.
Syntax:
MID(text; start; number)
returns
number
characters from the text
text
, starting at position
start
.
Example:
MID("output"; 3; 2)
returns
tp
.
See Also
LEFT
RIGHT
LEN
Text functions
Functions listed alphabetically
Functions listed by category
Category
:
Documentation/Reference/Calc/Text functions
Views
Page
Discussion
View source
History
Personal tools
Log in
Navigation
Main Page
Recent changes
Download AOO
Documentation
User Forum
Extensions
Templates
Wiki Help
Print/export
Create a book
Download as PDF
Printable version
Search
Tools
What links here
Related changes
Special pages
Permanent link
Page information