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.