---
title: "MIDDLE"
description: "MIDDLE"
keywords: "MIDDLE"
url: "https://myrapidi.com/wiki/middle"
locale: "en"
published: "2009-05-15T09:29:54Z"
modified: "2012-11-08T07:30:06Z"
---

# MIDDLE(data, substring);

Using this function, your program will return the middle string according to what you specify.

 

**Example:**

> The field value is  'One Two Three'.
> 
> MIDDLE(data, ' ');  
> Returns 'Two'.
> 
> MIDDLE(data, 'One');  
> Returns '0' (null).
> 
> MIDDLE(data, 'T');  
> Returns  'wo ' (with a blank at the end).