Why do we use trim?



Why do we use trim?..

Answer / Krishnapal Singh

The TRIM function in Excel removes extra spaces (including leading, trailing, and internal) from a text string. It helps to ensure data consistency when dealing with various sources or formats.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MS Excel Microsoft Interview Questions

How do I merge cells into one?

1 Answers  


What is pivot cache in excel vba?

1 Answers  


How do I make a dynamic drop down list in alphabetical order?

1 Answers  


How you can add a new excel worksheet?

1 Answers  


What is a data format?

1 Answers  


How do I update excel on my laptop?

1 Answers  


Why is vlookup used?

1 Answers  


What is the order of sequence of operating mathematical operation in excel?

1 Answers  


How do I remove numbers and keep text in excel?

1 Answers  


How do I show formula in one cell?

1 Answers  


How do you create a validation rule in excel?

1 Answers  


What is a table in excel?

1 Answers  


Categories