Using Data Pane Formulas

This page provides some useful formulas that can be used in the Data pane. Any combination of the formulas below is acceptable. The formulas refer to the data in cell A1 but may be applied to any cell.

For details on Data pane formulas, see the Microsoft Excel documentation. All Microsoft Excel formulas can be used in the Data pane.

VBScript/Data Pane formula samples

First word in a sentence:

Copy code
=LEFT(A1,SEARCH("",A1,1))

First three words in a sentence:

Copy code
=LEFT(A1,SEARCH("@",SUBSTITUTE(A1,"","@",3),1))

Part of the sentence starting with the fourth word:

Copy code
=MID(A1,SEARCH("@",SUBSTITUTE(A1,"","@",3),1),LEN(A1))

The part of the sentence starting with "word":

Copy code
=MID(A1,SEARCH("word",A1,1),LEN(A1))

Check if two strings are equal:

Copy code
=EXACT(A1,"text2")

Duplicate the string three times:

Copy code
=REPT(A1,3)

Concatenation of two strings:

Copy code
="Hello " & "There"

Today's date:

Copy code
=TODAY()

Generate a random uppercase letter:

Copy code
=CHAR((RAND() *26) +65)

Python sample

Copy code
import datetime
import random
import string

a1 = "word1 word2 word3 word4"

# First word in a sentence
first_word = a1.split()[0]

# First three words in a sentence
first_three = " ".join(a1.split()[:3])

# Part of sentence starting with fourth word
from_fourth = " ".join(a1.split()[3:])

# Part of sentence starting with "word"
start_idx = a1.find("word")
from_word = a1[start_idx:] if start_idx != -1 else ""

# Check if two strings are equal
is_equal = a1 == "text2"

# Duplicate the string three times
tripled = a1 * 3

# Concatenation of two strings
concat = "Hello " + "There"

# Today's date
today = datetime.date.today()

# Random uppercase letter
random_upper = random.choice(string.ascii_uppercase)