Showing posts with label String Functions. Show all posts
Showing posts with label String Functions. Show all posts

Count and Sum Functions

 

Count | Countif | Countifs | Sum | Sumif | Sumifs

The most used functions in Excel are the functions that count and sum. You can count and sum based on one criteria or multiple criteria.

Count

To count the number of cells that contain numbers, use the COUNT function.

Count Function

Countif

To count cells based on one criteria (for example, higher than 9), use the following COUNTIF function.

Countif Function

Countifs

To count cells based on multiple criteria (for example, green and higher than 9), use the following COUNTIFS function.

Countifs Function

Sum

To sum a range of cells, use the SUM function.

Sum Function

Sumif

To sum cells based on one criteria (for example, higher than 9), use the following SUMIF function (two arguments).

Sumif Function, Two Arguments

To sum cells based on one criteria (for example, green), use the following SUMIF function (three arguments, last argument is the range to sum).

Sumif Function, Three Arguments

Sumifs

To sum cells based on multiple criteria (for example, blue and green), use the following SUMIFS function (first argument is the range to sum).

Sumifs Function

General note: in a similar way, you can use the AVERAGEIF and AVERAGEIFS function to average cells based on one or multiple criteria.

This Excel tutorial explains how to use the Excel VALUE function with syntax and examples.

Description

The Microsoft Excel VALUE function converts a text value that represents a number to a number.

Syntax

The syntax for the Microsoft Excel VALUE function is:
VALUE( text )

Parameters or Arguments

text is the text value to convert to a number. If text is not a number, the VALUE function will return #VALUE!.

Applies To

The VALUE function can be used in the following versions of Microsoft Excel:
  • Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000

Type of Excel Function

The VALUE function can be used in Microsoft Excel as the following type of function:
  • Worksheet function (WS)

Example (as Worksheet Function)

Let's look at some Excel VALUE function examples and explore how to use the VALUE function as a worksheet function in Microsoft Excel:
Microsoft Excel
Based on the spreadsheet above, the following Excel VALUE examples would return:
=VALUE(A1)
Result: 12345

=VALUE(A2)
Result: 768.8

=VALUE(A3)
Result: #VALUE!

=VALUE("67")
Result: 67
This Excel tutorial explains how to use the Excel VAL function with syntax and examples.

Description

The Microsoft Excel VAL function accepts a string as input and returns the numbers found in that string.

Syntax

The syntax for the Microsoft Excel VAL function is:
Val( string )

Parameters or Arguments

string is a string expression.

Note

  • The VAL function will stop reading the string once it encounters the first non-numeric character. This does not include spaces.

Applies To

The VAL function can be used in the following versions of Microsoft Excel:
  • Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000

Type of Excel Function

The VAL function can be used in Microsoft Excel as the following type of function:
  • VBA function (VBA)

Example (as VBA Function)

The VAL function can only be used in VBA code in Microsoft Excel.
Let's look at some Excel VAL function examples and explore how to use the VAL function in Excel VBA code:
Val("10 Main Street")
Result: 10

Val("34 10 Main Street")
Result: 3410

Val("  34 10 Main Street")
Result: 3410

Val("  34 - 10 Main Street")
Result: 34

Val("075")
Result: 75
For example:
Dim LNumber As Double

LNumber = Val("56.2 tables")
This Excel tutorial explains how to use the Excel UPPER function with syntax and examples.

Description

The Microsoft Excel UPPER function allows you to convert text to all uppercase.

Syntax

The syntax for the Microsoft Excel UPPER function is:
UPPER( text )

Parameters or Arguments

text is the string that you wish to convert to uppercase.

Applies To

The UPPER function can be used in the following versions of Microsoft Excel:
  • Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000

Type of Excel Function

The UPPER function can be used in Microsoft Excel as the following type of function:
  • Worksheet function (WS)

Example (as Worksheet Function)

Let's look at some Excel UPPER function examples and explore how to use the UPPER function as a worksheet function in Microsoft Excel:
Microsoft Excel
Based on the spreadsheet above, the following Excel UPPER examples would return:
=UPPER(A1)
Result: "ALPHABET SOUP"

=UPPER(A2)
Result: "TECHONTHENET.COM"

=UPPER("Excel")
Result: "EXCEL"

=UPPER("123abc")
Result: "123ABC"
This Excel tutorial explains how to use the Excel UCASE function with syntax and examples.

Description

The Microsoft Excel UCASE function converts a string to all upper-case.

Syntax

The syntax for the Microsoft Excel UCASE function is:
UCase( text )

Parameters or Arguments

text is the string that you wish to convert to upper-case.

Applies To

The UCASE function can be used in the following versions of Microsoft Excel:
  • Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000

Type of Excel Function

The UCASE function can be used in Microsoft Excel as the following type of function:
  • VBA function (VBA)

Example (as VBA Function)

The UCASE function can only be used in VBA code in Microsoft Excel.
Let's look at some Excel UCASE function examples and explore how to use the UCASE function in Excel VBA code:
UCase("Tech on the Net")
Result: "TECH ON THE NET"

UCase("Alphabet")
Result: "ALPHABET"
For example:
Dim LResult As String

LResult = UCase("This is a TEST")
This Excel tutorial explains how to use the Excel TRIM function with syntax and examples.

Description

The Microsoft Excel TRIM function returns a text value with the leading and trailing spaces removed.

Syntax

The syntax for the Microsoft Excel TRIM function is:
TRIM( text )

Parameters or Arguments

text is the text value to remove the leading and trailing spaces from.

Applies To

The TRIM function can be used in the following versions of Microsoft Excel:
  • Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000

Type of Excel Function

The TRIM function can be used in Microsoft Excel as the following type of function:
  • Worksheet function (WS)
  • VBA function (VBA)

Example (as Worksheet Function)

Let's look at some Excel TRIM function examples and explore how to use the TRIM function as a worksheet function in Microsoft Excel:
Microsoft Excel
Based on the spreadsheet above, the following Excel TRIM examples would return:
=TRIM(A1)
Result: "Tech on the Net"

=TRIM(A2)
Result: "1234"

=TRIM(A3)
Result: "alphabet soup"

=TRIM(A4)
Result: "www.techonthenet.com"

=TRIM("  apples ")
Result: "apples"

Example (as VBA Function)

The TRIM function can also be used in VBA code in Microsoft Excel.
Let's look at some Excel TRIM function examples and explore how to use the TRIM function in Excel VBA code:
Dim LResult As String

LResult = Trim ("   Alphabet   ")
This Excel tutorial explains how to use the Excel TEXT function with syntax and examples.

Description

The Microsoft Excel TEXT function returns a value converted to text with a specified format.

Syntax

The syntax for the Microsoft Excel TEXT function is:
TEXT( value, format )

Parameters or Arguments

value is the value to convert to text.
format is the format to display the results in.

Applies To

The TEXT function can be used in the following versions of Microsoft Excel:
  • Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000

Type of Excel Function

The TEXT function can be used in Microsoft Excel as the following type of function:
  • Worksheet function (WS)

Example (as Worksheet Function)

Let's look at some Excel TEXT function examples and explore how to use the TEXT function as a worksheet function in Microsoft Excel:
Microsoft Excel
Based on the spreadsheet above, the following Excel TEXT examples would return:
=TEXT(A1, "$#,##0.00")
Result: "$7,678.87"

=TEXT(A1, "0")
Result: "7679"

=TEXT(A2, "0.0")
Result: "123.7"

=TEXT(1277, "#,##0")
Result: "1,277"

=TEXT(C1, "yyyy/mm/dd")
Result: "2003/12/12"

=TEXT(C1, "mmm dd, yyyy")
Result: "Dec 12, 2003"
This Excel tutorial explains how to use the Excel T function with syntax and examples.

Description

The Microsoft Excel T function returns the text referred to by a value.

Syntax

The syntax for the Microsoft Excel T function is:
T( value )

Parameters or Arguments

value is the to extract the text from.

Applies To

The T function can be used in the following versions of Microsoft Excel:
  • Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000

Type of Excel Function

The T function can be used in Microsoft Excel as the following type of function:
  • Worksheet function (WS)

Example (as Worksheet Function)

Let's look at some Excel T function examples and explore how to use the T function as a worksheet function in Microsoft Excel:
Microsoft Excel
Based on the spreadsheet above, the following Excel T examples would return:
=T(A1)
Result: "Alphabet soup"

=T(A2)
Result: "techonthenet"

=T(A3)
Result: "34 hats"

=T(A4)
Result: ""

=T(A5)
Result: "techonthenet.com"

=T("56")
Result: "56"

=T(56)
Result: ""

=T(TRUE)
Result: ""
This Excel tutorial explains how to use the Excel SUBSTITUTE function with syntax and examples.

Description

The Microsoft Excel SUBSTITUTE function replaces a set of characters with another.

Syntax

The syntax for the Microsoft Excel SUBSTITUTE function is:
SUBSTITUTE( text, old_text, new_text, [nth_appearance] )

Parameters or Arguments

text is the original string to use to perform the substitution.
old_text is the existing characters to replace.
new_text is the new characters to replace old_text with.
nth_appearance is optional. It is the nth appearance of old_text that you wish to replace. I f this parameter is omitted, then every occurrence of old_text will be replaced with new_text.

Applies To

The SUBSTITUTE function can be used in the following versions of Microsoft Excel:
  • Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000

Type of Excel Function

The SUBSTITUTE function can be used in Microsoft Excel as the following type of function:
  • Worksheet function (WS)

Example (as Worksheet Function)

Let's look at some Excel SUBSTITUTE function examples and explore how to use the SUBSTITUTE function as a worksheet function in Microsoft Excel:
Microsoft Excel
Based on the spreadsheet above, the following Excel SUBSTITUTE examples would return:
=SUBSTITUTE(A1, "bet", "con", 1)
Result: "Alphacon soup"

=SUBSTITUTE(A2, "t", "4", 2)
Result: "techon4henet.com"

=SUBSTITUTE(A2, "t", "4")
Result: "4echon4hene4.com"
This Excel tutorial explains how to use the Excel STRCONV function with syntax and examples.

Description

The Microsoft Excel STRCONV function returns a string converted as specified.

Syntax

The syntax for the Microsoft Excel STRCONV function is:
StrConv ( text, conversion, LCID )

Parameters or Arguments

text is the string that you wish to convert.
conversion is the type of conversion to perform. The following is a list of valid parameters for conversion.
Parameter Value Description
vbUpperCase 1 Converts the string to all uppercase.
vbLowerCase 2 Converts the string to all lowercase.
vbProperCase 3 Converts the first letter to every word to uppercase. All other characters are left as lowercase. This option is similar to the InitCap function in Oracle.
vbUnicode 64 Converts the string to Unicode.
vbFromUnicode 128 Converts the string from Unicode to the default code page of the system.
LCID is optional. If this parameter is omitted, the STRCONV function assumes the system LocaleID.

Applies To

The STRCONV function can be used in the following versions of Microsoft Excel:
  • Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000

Type of Excel Function

The STRCONV function can be used in Microsoft Excel as the following type of function:
  • VBA function (VBA)

Example (as VBA Function)

The STRCONV function can only be used in VBA code in Microsoft Excel.
Let's look at some Excel STRCONV function examples and explore how to use the STRCONV function in Excel VBA code:
StrConv("tech on the net", 1)
Result: "TECH ON THE NET"

StrConv("TECH ON THE NET", 2)
Result: "tech on the net"

StrConv("TECH ON THE NET", 3)
Result: "Tech On The Net"
For example:
Dim LResult As String

LResult = StrConv("TECH ON THE NET", vbProperCase)
This Excel tutorial explains how to use the Excel STRCOMP function with syntax and examples.

Description

The Microsoft Excel STRCOMP function returns an integer value representing the result of a string comparison.

Syntax

The syntax for the Microsoft Excel STRCOMP function is:
StrComp ( string1, string2 [, compare ] )

Parameters or Arguments

string1 and string2 are the two strings to compare to each other.
compare is optional. This is the type of comparison to perform. The valid choices are:
VBA Constant Value Explanation
vbUseCompareOption -1 Uses option compare
vbBinaryCompare 0 Binary comparison
vbTextCompare 1 Textual comparison

Note

  • If string1 is equal to string2, the StrComp function will return 0.
  • If string1 is less than string2, the StrComp function will return -1.
  • If string1 is greater than string2, the StrComp function will return 1.
  • If either string1 or string2 is NULL, the StrComp function will return NULL.

Applies To

The STRCOMP function can be used in the following versions of Microsoft Excel:
  • Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000

Type of Excel Function

The STRCOMP function can be used in Microsoft Excel as the following type of function:
  • VBA function (VBA)

Example (as VBA Function)

The STRCOMP function can only be used in VBA code in Microsoft Excel.
Let's look at some Excel STRCOMP function examples and explore how to use the STRCOMP function in Excel VBA code:
StrComp ("TechOnTheNet.com", "TechOnTheNet.com")
Result: 0

StrComp ("TechOnTheNet.com", "Abc")
Result: 1

StrComp ("TechOnTheNet.com", "Xyz")
Result: -1

StrComp ("TechOnTheNet.com", NULL)
Result: NULL
For example:
Dim LResult As Integer

LResult = StrComp ("TechOnTheNet.com", "TechOnTheNet.com")
This Excel tutorial explains how to use the Excel STR function with syntax and examples.

Description

The Microsoft Excel STR function returns a string representation of a number.

Syntax

The syntax for the Microsoft Excel STR function is:
Str( number )

Parameters or Arguments

number is the value to convert to a string.

Applies To

The STR function can be used in the following versions of Microsoft Excel:
  • Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000

Type of Excel Function

The STR function can be used in Microsoft Excel as the following type of function:
  • VBA function (VBA)

Example (as VBA Function)

The STR function can only be used in VBA code in Microsoft Excel.
Let's look at some Excel STR function examples and explore how to use the STR function in Excel VBA code:
STR(12)
Result: "12"

STR(450)
Result: "450"
For example:
Dim LResult As String

LResult = Str(16)
This Excel tutorial explains how to use the Excel SPACE function with syntax and examples.

Description

The Microsoft Excel SPACE function returns a string with a specified number of spaces.

Syntax

The syntax for the Microsoft Excel SPACE function is:
Space( number )

Parameters or Arguments

number is the number of spaces to be returned.

Applies To

The SPACE function can be used in the following versions of Microsoft Excel:
  • Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000

Type of Excel Function

The SPACE function can be used in Microsoft Excel as the following type of function:
  • VBA function (VBA)

Example (as VBA Function)

The SPACE function can only be used in VBA code in Microsoft Excel.
Let's look at some Excel SPACE function examples and explore how to use the SPACE function in Excel VBA code:
Space(3)
Result: "   "

Space(7)
Result: "       "
For example:
Dim LResult As String

LResult = Space(5)
This Excel tutorial explains how to use the Excel SEARCH function with syntax and examples.

Description

The Microsoft Excel SEARCH function returns the location of a substring in a string. The search is NOT case-sensitive.

Syntax

The syntax for the Microsoft Excel SEARCH function is:
SEARCH( substring, string, [start_position] )

Parameters or Arguments

substring is the substring that you want to find.
string is the string to search within.
start_position is optional. It is the position in string where the search will start. The first position is 1.

Note

  • If the SEARCH function does not find a match, it will return a #VALUE! error.

Applies To

The SEARCH function can be used in the following versions of Microsoft Excel:
  • Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000

Type of Excel Function

The SEARCH function can be used in Microsoft Excel as the following type of function:
  • Worksheet function (WS)

Example (as Worksheet Function)

Let's look at some Excel SEARCH function examples and explore how to use the SEARCH function as a worksheet function in Microsoft Excel:
Microsoft Excel
Based on the spreadsheet above, the following Excel SEARCH examples would return:
=SEARCH("bet", A1)
Result: 6

=SEARCH("BET", A1, 3)
Result: 6

=SEARCH("e", A2)
Result: 2

=SEARCH("e", A2, 1)
Result: 2

=SEARCH("e", A2, 3)
Result: 9

=SEARCH("in", A2, 6)
Result: #VALUE!

=SEARCH("cel", "Excel", 1)
Result: 3
This Excel tutorial explains how to use the Excel RTRIM function with syntax and examples.

Description

The Microsoft Excel RTRIM function removes trailing spaces from a string.

Syntax

The syntax for the Microsoft Excel RTRIM function is:
RTrim( text )

Parameters or Arguments

text is the string that you wish to remove trailing spaces from.

Applies To

The RTRIM function can be used in the following versions of Microsoft Excel:
  • Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000

Type of Excel Function

The RTRIM function can be used in Microsoft Excel as the following type of function:
  • VBA function (VBA)

Example (as VBA Function)

The RTRIM function can only be used in VBA code in Microsoft Excel.
Let's look at some Excel RTRIM function examples and explore how to use the RTRIM function in Excel VBA code:
RTrim("Tech on the Net  ")
Result: "Tech on the Net"

RTrim("  Alphabet  ")
Result: "  Alphabet"
For example:
Dim LResult As String

LResult = RTrim("   Alphabet   ")
This Excel tutorial explains how to use the Excel RIGHT function with syntax and examples.

Description

The Microsoft Excel RIGHT function extracts a substring from a string starting from the right-most character.

Syntax

The syntax for the Microsoft Excel RIGHT function is:
RIGHT( text, [number_of_characters] )

Parameters or Arguments

text is the string that you wish to extract from.
number_of_characters is optional. It indicates the number of characters that you wish to extract starting from the right-most character. If this parameter is omitted, only 1 character is returned.

Applies To

The RIGHT function can be used in the following versions of Microsoft Excel:
  • Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000

Type of Excel Function

The RIGHT function can be used in Microsoft Excel as the following type of function:
  • Worksheet function (WS)
  • VBA function (VBA)

Example (as Worksheet Function)

Let's look at some Excel RIGHT function examples and explore how to use the RIGHT function as a worksheet function in Microsoft Excel:
Microsoft Excel
Based on the spreadsheet above, the following Excel RIGHT examples would return:
=RIGHT(A1, 4)
Result: "soup"

=RIGHT("techonthenet", 6)
Result: "thenet"

=RIGHT(A2, 6)
Result: "et.com"

=RIGHT("Excel", 3)
Result: "cel"

=RIGHT("Microsoft")
Result: "t"

Example (as VBA Function)

The RIGHT function can also be used in VBA code in Microsoft Excel.
Let's look at some Excel RIGHT function examples and explore how to use the RIGHT function in Excel VBA code:
Dim LResult As String

LResult = Right("Alphabet",3)
This Excel tutorial explains how to use the Excel REPT function with syntax and examples.

Description

The Microsoft Excel REPT function returns a repeated text value a specified number of times.

Syntax

The syntax for the Microsoft Excel REPT function is:
REPT( text, number )

Parameters or Arguments

text is the text value to repeat.
number is the number of times to repeat the text value.

Applies To

The REPT function can be used in the following versions of Microsoft Excel:
  • Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000

Type of Excel Function

The REPT function can be used in Microsoft Excel as the following type of function:
  • Worksheet function (WS)

Example (as Worksheet Function)

Let's look at some Excel REPT function examples and explore how to use the REPT function as a worksheet function in Microsoft Excel:
Microsoft Excel
Based on the spreadsheet above, the following Excel REPT examples would return:
=REPT(A1, 3)
Result: "abcdabcdabcd"

=REPT(A2, 2)
Result: "isis"

=REPT("apples", 2)
Result: "applesapples"
This Excel tutorial explains how to use the Excel REPLACE function (in VBA) with syntax and examples.

Description

The Microsoft Excel REPLACE function replaces a sequence of characters in a string with another set of characters. Please note that the worksheet version of the REPLACE function has different syntax.

Syntax

The syntax for the Microsoft Excel REPLACE function is:
Replace ( string1, find, replacement, [start, [count, [compare]]] )

Parameters or Arguments

string1 is the string to replace a sequence of characters with another set of characters.
find is the string that will be searched for in string1.
replacement will replace find in string1.
start is optional. This is the position in string1 to begin the search. If this parameter is omitted, the REPLACE function will begin the search at position 1.
count is optional. This is the number of occurrences to replace. If this parameter is omitted, the REPLACE function will replace all occurrences of find with replacement.
compare is optional. This can be one of the following values:
Parameter Value Description
vbBinaryCompare Binary comparison
vbTextCompare Textual comparison

Applies To

The REPLACE function can be used in the following versions of Microsoft Excel:
  • Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000

Type of Excel Function

The REPLACE function can be used in Microsoft Excel as the following type of function:
  • VBA function (VBA)

Example (as VBA Function)

The REPLACE function can be used in VBA code in Microsoft Excel.
Let's look at some Excel REPLACE function examples and explore how to use the REPLACE function in Excel VBA code:
Replace("alphabet", "bet", "hydro")
Result: "alphahydro"

Replace ("alphabet", "a", "e")
Result: "elphebet"

Replace("alphabet", "a", "e", 2)
Result: "lphebet"

Replace("alphabet", "a", "e", 1, 1)
Result: "elphabet"
For example:
Dim LResult As String

LResult = Replace("alphabet", "a", "e")
This Excel tutorial explains how to use the Excel REPLACE function with syntax and examples.

Description

The Microsoft Excel REPLACE function replaces a sequence of characters in a string with another set of characters. Please note that the VBA version of the REPLACE function has different syntax.

Syntax

The syntax for the Microsoft Excel REPLACE function is:
REPLACE( old_text, start, number_of_chars, new_text )

Parameters or Arguments

old_text is the original string value.
start is the position in old_text to begin replacing characters.
number_of_chars is the number of characters to replace in old_text.
new_text is the replacement set of characters

Applies To

The REPLACE function can be used in the following versions of Microsoft Excel:
  • Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000

Type of Excel Function

The REPLACE function can be used in Microsoft Excel as the following type of function:
  • Worksheet function (WS)

Example (as Worksheet Function)

Let's look at some Excel REPLACE function examples and explore how to use the REPLACE function as a worksheet function in Microsoft Excel:
Microsoft Excel
Based on the spreadsheet above, the following Excel REPLACE examples would return:
=REPLACE(A1, 1, 5, "Beta")
Result: "Betabet Soup"

=REPLACE(A2, 5, 2, "1234")
Result: "tech1234thenet.com"

=REPLACE("apples", 2, 5, "te")
Result: "ate"
This Excel tutorial explains how to use the Excel PROPER function with syntax and examples.

Description

The Microsoft Excel PROPER function sets the first character in each word to uppercase and the rest to lowercase.

Syntax

The syntax for the Microsoft Excel PROPER function is:
PROPER( text )

Parameters or Arguments

text is the string argument whose first character in each word will be converted to uppercase and all remaining characters converted to lowercase.

Applies To

The PROPER function can be used in the following versions of Microsoft Excel:
  • Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000

Type of Excel Function

The PROPER function can be used in Microsoft Excel as the following type of function:
  • Worksheet function (WS)

Example (as Worksheet Function)

Let's look at some Excel PROPER function examples and explore how to use the PROPER function as a worksheet function in Microsoft Excel:
Microsoft Excel
Based on the spreadsheet above, the following Excel PROPER examples would return:
=PROPER(A1)
Result: "Alphabet Soup"

=PROPER(A2)
Result: "Tech On The Net"

=PROPER(A3)
Result: "Alpha Beta"

=PROPER("excel")
Result: "Excel"

Total Pageviews

2016 © BiztechCS
Planer theme by BiztechCS