Trim

The Trim function is a feature that removes extra spaces from text within your cells, except for single spaces between words.

See it in Action

Requirements

Data

• Target Data

  • Data Range: Identify the cells range where you want to apply the function.

  • Columns Included: Check this option if your selected range includes the first row as column headers. This ensures that the first row is recognized as column names and excluded from the processing.

Fill empty cells with

• Keep Empty: Leave cells that are empty as is, without adding any text.

• Forward Fill: Copy the value from the nearest non-empty cell above into empty cells before adding the specified letters or text.

• Backward Fill: Copy the value from the nearest non-empty cell below into empty cells before adding the specified letters or text.

• -: Fill empty cells with a letter "-".

• 0: Fill empty cells with a letter "0".

• Custom: Allows for a custom value or text to be inserted into empty cells prior to adding the specified letters.

Result Destination

Specify the starting cell where the results will be placed.