Concatenate := by this command we can
join several number s of text.
Left:-LEFT returns the first character
or characters in a text string, based on the number of characters you specify.
Right :- RIGHT returns the last
character or characters in a text string, based on the number of characters you
specify.
LOWER:-TO Convert all uppercase letters in a text string to
lowercase.
UPPER :- TO CONVERT ALL LOWER CASE
LETTERS IN A TEXT STRING TO UPPER CASE.
PROPER:-Capitalizes the first letter in
a text string and any other letters in text that follow any character other
than a letter. Converts all other letters to lowercase letters.
Date
and time :-date :-to make a date and time code of any date.
Look
up:- hlook up:-Searches for a value in the top row of a table or an
array (array: Used to build single formulas that produce multiple results
or that operate on a group of arguments that are arranged in rows and columns.
An array range shares a common formula; an array constant is a group of
constants used as an argument.) of values, and then returns a value in the same
column from a row you specify in the table or array. Use HLOOKUP when your
comparison values are located in a row across the top of a table of data, and
you want to look down a specified number of rows. Use VLOOKUP when your
comparison values are located in a column to the left of the data you want to
find.
Math and trig function :-ABS :- TO GET THE NUMBER WITHOUT
SIGN.
EVEN :- TOGET THE EVEN NUMBER OF ANY
ODD NUMBER
ODD:-TO GET THE ODD NUMBER OF ANY EVEN
NUMBER.
0 Comments
thank you