Insert Letters

The Insert Letters function is a feature that enables you to automatically append letters or text to specific data within your cells, enhancing data consistency and readability.

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.

• Letters to Insert: Input the letters or text you wish to insert into your target data.

• Position to Insert letters to: Define the position within the cell text where your additional letters should be placed. Positioning starts at 0, meaning the beginning of the cell's text. For example, to add "ID-" at the very start of "Test-111", choose 0 to get "ID-Test-111". If you prefer to insert "ID-" after "Test", selecting 4 will change it to "Test-ID-111".

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.