How do you use the left function in excel?



How do you use the left function in excel?..

Answer / Paramjeet Kaur

The LEFT function in Excel returns a specified number of characters from the left side of a text string. The syntax is: LEFT(text, number_of_characters). For example, if you have a cell A1 with the text 'Apple' and want to get the first 3 characters, you could use the formula: =LEFT(A1, 3) which would return "App"

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MS Excel Microsoft Interview Questions

How do you hide columns in excel 2016?

1 Answers  


How do I add a design tab in excel?

1 Answers  


How do I get rid of infinite rows in excel?

1 Answers  


What are good excel skills?

1 Answers  


How many sheets are there in excel workbook by default?

1 Answers  


My question is when your working with multiple worksheets how do you transfer added figures from one worksheet to another without losing the total?

1 Answers  


What does the if function do in excel?

1 Answers  


What is text in excel?

1 Answers  


How do you fill in excel without dragging?

1 Answers  


How do I combine text and numbers in excel?

1 Answers  


How do you match data in two columns?

1 Answers  


How do you check if a cell contains a specific text in excel?

1 Answers  


Categories