Microsoft Office Tutorials and References
In Depth Information
APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE
not been registered, this function registers the DLL or code resource and then
returns the register ID for Windows.
REPLACE(old_text,start_num,num_chars,new_text) [Category: Text]
REPLACE replaces part of a text string, based on the number of characters
you specify, with a different text string. Guru Tip: I am betting you don’t want
REPLACE. You really want SUBSTITUTE. See SUBSTITUTE.
REPLACEB(old_text,start_num,num_bytes,new_text) [Category: Text]
REPLACEB replaces part of a text string, based on the number of bytes you
specify, with a different text string. This function is for use with double-byte
characters.
REPT(text,number_times) [Category: Text]
Repeats text a given number of times. Use REPT to fi ll a cell with a number of
instances of a text string. Guru Tip: create in-cell bar charts using REPT and the
pipe character as shown below:
RIGHT(text,num_chars) [Category: Text]
RIGHT returns the last character or characters in a text string, based on the
number of characters you specify. Guru Tip: See an example under LEFT where
you can extract a specifi c number of characters from the right side of text. In
many cases, you will have to use LEN and FIND to calculate the number of
characters.
 
Search JabSto ::




Custom Search