Text and data - Excel - Microsoft Office Online

Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Text and data

Documents 1-25 of 28

Page: [1] 2 Go to previous page (disabled)

Text functions (reference)

ASC function

BAHTTEXT function

CHAR function

CLEAN function

CODE function

CONCATENATE function

DOLLAR function

=EXACT(text1,text2)

FIND, FINDB functions

FIXED function

JIS function

LEFT, LEFTB functions

LEN, LENB functions

LOWER function

MID, MIDB functions

PHONETIC function

PROPER function

REPLACE, REPLACEB functions

REPT function

RIGHT, RIGHTB functions

SEARCH, SEARCHB functions

SUBSTITUTE function

T function

=TEXT(value, format text)

Documents 1-25 of 28

Page: [1] 2 Go to previous page (disabled)

Related Web Sites

» Product Support
» Microsoft.com

» Microsoft Update
» TechNet

» Office for Mac
» Office Community

Site Help | Accessibility | Contact Us | My Office.com | Office Worldwide Click here to switch to other Office Online sites worldwide