Answer :

Answer:

The TRIM function in Excel eliminates extra space in data, helping clean up the cells in the worksheet. It removes leading, trailing, and intervening spaces, leaving only a single space character between words and no space characters at the start or end of text.

Explanation:

A trim command (known as TRIM in the ATA command set, and UNMAP in the SCSI command set) allows an operating system to inform a solid-state drive (SSD) which blocks of data are no longer considered to be "in use" and therefore can be erased internally. Trim was introduced soon after SSDs were introduced.

Other Questions