---
title: "Extracting Text from a Column"
description: "Effortlessly extract text from a column with precision and ease."
url: https://help.stackby.com/es/articles/55-extracting-text-from-a-column
collection: "Using Formulas"
updated: 2025-01-10
language: es
alternates: [en]
---

# Extracting Text from a Column

Effortlessly extract text from a column with precision and ease.

## **1\. LEN ()** 

LEN returns the length of a string. You can reference a value/column/string within the function following this format: LEN({COLUMN NAME})

![](https://d258lu9myqkejp.cloudfront.net/attachment_images/743011e249c9cb23189489754404ad148fbad0719ebb5678456597a99f267e6f1657189385254.png)

**Result:**

![](https://d258lu9myqkejp.cloudfront.net/attachment_images/a94d0a7154169bf0bb3a63877d0a737f8fb5bb10294b3fd81422831bc13408841657189434757.png)

![](https://staticfiles.gleap.io/ghelparticle/Qj0RJBuOeYIwt6cGcg1LcqvagG8WslMAdIuzBjcNMBn3I9QzRNRNRBWUG5a8thVwL1Ig9vneIBu.png)

**Some of the interesting ways you can use LEN () function** 

**Displaying a message based on character count**

Here, we can use IF statements to know whether characters are under 35 limit and output a message depending on the character count. Whether you want to count characters in your tweet or managing your SEO title & meta descriptions, you can use the function below: 

![](https://d258lu9myqkejp.cloudfront.net/attachment_images/c251d57f70d29a0a5dc81577b5f5e6d05dfc82d1b770efbfa5e61b392970310b1657189491333.png)

**Result:**

![](https://d258lu9myqkejp.cloudfront.net/attachment_images/8b72bb99de7e5e5fe986d2497cafdbd480bd9e99e405b66186453b08c88cf53b1657189543055.png)

## **2\. Counting words**

You can use a similar formula to count the number of spaces in a text field, which in turn will give you a total count of words.

**Formula:** 

![](https://d258lu9myqkejp.cloudfront.net/attachment_images/99c5be9baea5f2897eeda256859ce10fa6fb67af0fabdea1fa332d4a0af840951657189618955.png)

**Result:**

![](https://d258lu9myqkejp.cloudfront.net/attachment_images/4a24daff2bd2b0e8c0138dabbc9e8f0622e1400d81be2cd37124c43b5f4bf34d1657189651092.png)

## **3\. LEFT() and RIGHT()**

The LEFT() and RIGHT() functions work similarly to one another by extracting a certain number of characters from the beginning (left) or end (right) of a string.

These are helpful functions to use when you need to extract data from a number of rows that share a similar structure.

![](https://d258lu9myqkejp.cloudfront.net/attachment_images/691ef7e5d7130f6d49ce95f2feb9d32d78e0ba7bc3f2255010f91734aae8f04c1657189768223.png)

**Syntax:** LEFT(String, howMany)  
**Example:** 

![IMAGE](https://d258lu9myqkejp.cloudfront.net/attachment_images/63ec444fc93992249b0bcd106424dd3626da52ec97896f23af110eae9440d5821657189726259.png)

**Result:**

![](https://d258lu9myqkejp.cloudfront.net/attachment_images/691ef7e5d7130f6d49ce95f2feb9d32d78e0ba7bc3f2255010f91734aae8f04c1657189768223.png)

## **4\. MID()**

This function lets you extract a certain number of characters starting at a specific place within a string.

**Syntax:** MID(String, wheretostart, count)

**Example:**

![](https://d258lu9myqkejp.cloudfront.net/attachment_images/a605c77017d10995ff912438facef8a9dcb8a0052c3eb02b767d71fa6a5ee43b1657195550591.png)

**Result****:**

![](https://d258lu9myqkejp.cloudfront.net/attachment_images/a8b5bf49373c9634c55f36de0acc49dd4c1d0429877d382466da185bbe9250031657195638641.png)