Advanced EXCEL
Using Calculated Field
CONCATENATE( ) – used to join several text strings to one string
TEXT( ) – Converting a value into text formatting
PROPER ( ) – Arranging the characters in a proper way.
LEFT ( ) – Returns the specified number of characters from the starting character.
TEXT( ) – Converting a value into text formatting
PROPER ( ) – Arranging the characters in a proper way.
LEFT ( ) – Returns the specified number of characters from the starting character.
*/?>
*/?>
*/?>
*/?>