Mr. A, while filling the form in excel, by mistake hits the space key several times and then fills the name in the name column. Which function can be used to remove the spaces from the cell?
Reveal answer
Fill a bubble to check yourself
Keep practicing — related questions
- which function is used to clear leading or trailing spaces or infact any other characters?
- Using which of the following keyboard options can one delete the selected column or row in MS-Excel?
- Which of the following key combinations is used to select the entire column in MS Excel?
- Which function would you use to compare cell contents
- Which method of the String class is used to remove the leading and trailing blank spaces from the string?
- The LEN function does what?
- In excel, Ctrl+backspace is used for ?
- In excel, like Ctrl+C is for "copy" then Ctrl+H is for ?