writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 50:
Line 50: +
no edit summary
=LEFT(A1,8) : Displays first 8 characters in a string from cell A1. Displays '''Wel-Come''' as the output.
=LEFT(A1,8) : Displays first 8 characters in a string from cell A1. Displays '''Wel-Come''' as the output.
=LEFT(A2,5) : Displays first 5 characters in a string from cell A2. Displays '''JOHN ''' as the output. Space Character is also counted.
=LEFT(A2,5) : Displays first 5 characters in a string from cell A2. Displays '''JOHN ''' as the output. Space Character is also counted.
=LEFT(A2) : Displays first character '''J''' in a string from cell A2 as the output.
=LEFT(A3,4) : Displays first 4 characters in a string from cell A3. Displays '''123*''' as the output.
=LEFT(A3,4) : Displays first 4 characters in a string from cell A3. Displays '''123*''' as the output.
=LEFT("Good Morning",20) :Displays the full text string '''Good Morning''' as the output.
=LEFT("Good Morning",20) :Displays the full text string '''Good Morning''' as the output.