(C) 2012 - 2018 by Mourad Louha · All rights reserved.

Text functions

REPLACE

Categories: Functions, Text
Comments: No

Description

The description for the function REPLACE is not available yet.

Availability

The REPLACE function is available in the following Microsoft Excel versions.

ProductAvailableCategoryNotes
Excel 2013YesText
Excel 2010YesText
Excel 2007YesText
Excel 2003YesText

Syntax

REPLACE(Old_text,Start_num,Num_chars,New_text)

Arguments

The REPLACE has the following arguments. Required arguments are bold.

DesignationDescription
Old_text
Start_num
Num_chars
New_text

 


REPT

Categories: Functions, Text
Comments: No

Description

The description for the function REPT is not available yet.

Availability

The REPT function is available in the following Microsoft Excel versions.

ProductAvailableCategoryNotes
Excel 2013YesText
Excel 2010YesText
Excel 2007YesText
Excel 2003YesText

Syntax

REPT(Text,Number_times)

Arguments

The REPT has the following arguments. Required arguments are bold.

DesignationDescription
Text
Number_times

 


RIGHT

Categories: Functions, Text
Comments: No

Description

The description for the function RIGHT is not available yet.

Availability

The RIGHT function is available in the following Microsoft Excel versions.

ProductAvailableCategoryNotes
Excel 2013YesText
Excel 2010YesText
Excel 2007YesText
Excel 2003YesText

Syntax

RIGHT(Text,Num_chars)

Arguments

The RIGHT has the following arguments. Required arguments are bold.

DesignationDescription
Text
Num_chars

 


SEARCH

Categories: Functions, Text
Comments: No

Description

The description for the function SEARCH is not available yet.

Availability

The SEARCH function is available in the following Microsoft Excel versions.

ProductAvailableCategoryNotes
Excel 2013YesText
Excel 2010YesText
Excel 2007YesText
Excel 2003YesText

Syntax

SEARCH(Find_text,Within_text,Start_num)

Arguments

The SEARCH has the following arguments. Required arguments are bold.

DesignationDescription
Find_text
Within_text
Start_num

 


SUBSTITUTE

Categories: Functions, Text
Comments: No

Description

The description for the function SUBSTITUTE is not available yet.

Availability

The SUBSTITUTE function is available in the following Microsoft Excel versions.

ProductAvailableCategoryNotes
Excel 2013YesText
Excel 2010YesText
Excel 2007YesText
Excel 2003YesText

Syntax

SUBSTITUTE(Text,Old_text,New_text,Instance_num)

Arguments

The SUBSTITUTE has the following arguments. Required arguments are bold.

DesignationDescription
Text
Old_text
New_text
Instance_num

 


T

Categories: Functions, Text
Comments: No

Description

The description for the function T is not available yet.

Availability

The T function is available in the following Microsoft Excel versions.

ProductAvailableCategoryNotes
Excel 2013YesText
Excel 2010YesText
Excel 2007YesText
Excel 2003YesText

Syntax

T(Value)

Arguments

The T has the following arguments. Required arguments are bold.

DesignationDescription
Value

 


TEXT

Categories: Functions, Text
Comments: No

Description

The description for the function TEXT is not available yet.

Availability

The TEXT function is available in the following Microsoft Excel versions.

ProductAvailableCategoryNotes
Excel 2013YesText
Excel 2010YesText
Excel 2007YesText
Excel 2003YesText

Syntax

TEXT(Value,Format_text)

Arguments

The TEXT has the following arguments. Required arguments are bold.

DesignationDescription
Value
Format_text

 


TRIM

Categories: Functions, Text
Comments: No

Description

The description for the function TRIM is not available yet.

Availability

The TRIM function is available in the following Microsoft Excel versions.

ProductAvailableCategoryNotes
Excel 2013YesText
Excel 2010YesText
Excel 2007YesText
Excel 2003YesText

Syntax

TRIM(Text)

Arguments

The TRIM has the following arguments. Required arguments are bold.

DesignationDescription
Text

 

 
Top