Search Contextures Sites
Custom Search

Excel Text Function Videos

Watch these easy to follow videos, to see how to use SUBSTITUTE, SUBSTITUTE, TRIM and other Excel text functions.

Learn more about SUBSTITUTE, TRIM, and other text functions, in my ebook kit:

30 Excel Functions in 30 Days

ADDRESS Function

REPLACE Function

SUBSTITUTE Function

TEXT Function

TRIM Function

Excel Function Tutorials

ADDRESS Function

The ADDRESS function returns a cell address as text, based on a row and column number. It can return an absolute or relative address, in A1 or R1C1 style. A sheet name can also be included in the result.

In this video you'll see how to use ADDRESS to get a cell address from row and column numbers, find a cell value from row and column numbers, and return the address of the cell with the highest value.

REPLACE Function

The REPLACE function replaces characters within text, based on the number of characters, and starting position, specified.

In this video you'll see how to change area codes in phone numbers, replace the first space with a colon and space, and use nested REPLACE functions to insert hyphens

SUBSTITUTE Function

The SUBSTITUTE function replaces characters within text, for all instances, or for a specified occurrence.

In this video you'll see how to use SUBSTITUTE to change a region name in a report title, remove non-printing characters, and substitute a space character

TEXT Function

The TEXT function converts a date or number to text, and lets you specify the formatting by using special format strings.

Watch this short video to see the steps for combining text and formatting the results, using the TEXT function.

TRIM Function

The TRIM function removes all the spaces in a text string, except for single spaces between words.

In this video you'll see how to use TRIM to remove spaces from the start and end of a text string, remove all except single spaces between words, and you'll see that TRIM does NOT remove some special space characters that have been copied from websites.

Excel Function Tutorials

Sum Functions -- Sum Cells  

VLOOKUP Function  

INDEX / MATCH Functions  

Count Functions -- Count Cells  

INDIRECT Function  

Get All the Excel News

For regular Excel news, tips and videos, please sign up for the Contextures Excel newsletter. Your email address will never be shared with anyone else.

Search Contextures

Search Contextures Sites

 

More Function Tutorials

Functions List

30 Functions in 30 Days

COUNT / COUNTIF

INDEX / MATCH

TEXT

VLOOKUP

 

 

30 Excel Functions in 30 Days

 

 

 

 

 

 

 

 

Privacy Policy

 

Contextures Inc., Copyright 2016
All rights reserved.

 

Last updated: May 29, 2016 6:24 PM