Excel Text Cleaner - Delete Characters & Substrings from Selected Range

Clean Excel data by deleting custom characters, character sets, or substrings from a selected cell range. Remove text at specific positions with Aspose.Cells API for accurate data formatting.

Introduction: Remove Unwanted Characters with Precision

Easily clean and standardize your Excel data by removing specific, unwanted characters. Our add-in offers multiple, targeted ways to sanitize your cells:

  • Remove Custom Characters Delete any specific symbols you define. Simply enter each character into the field, and the add-in will instantly remove all instances from your selected cells. Perfect for eliminating unique delimiters, typos, or special marks.

  • Remove Character Sets (Bulk Cleaning)

    • Non-printing Characters: Cleanse your data of invisible characters that disrupt analysis and formatting. This includes line breaks, carriage returns, tabs, and other control characters (ASCII values 0-31, 127, 129, 141, 143, 144, and 157).

    • Text Characters (All Letters): Isolate numbers and symbols by stripping every letter (A-Z, a-z) from the selected range.

    • Numeric Characters (All Digits): Extract pure text by deleting all digits (0-9), ideal for cleaning product names or textual descriptions.

    • Symbols: Remove a wide array of symbolic clutter, including mathematical (e.g., ±, √), geometric (e.g., ∆, °), technical, currency (e.g., £, ¢), and letter-like symbols (e.g., ™, ®, ©).

    • Punctuation Marks: Achieve clean, punctuation-free text by deleting all punctuation marks like periods, commas, quotation marks, and hyphens.

  • Remove a Specific Substring Go beyond single characters and delete entire words or specific character sequences. Effortlessly remove common prefixes, suffixes, or any redundant text phrases from your datasets.

RemoveCharacters API

API Endpoint

PUT http://api.aspose.cloud/v4.0/cells/content/remove/characters

The request parameters of removeCharacters API are

Parameter Name Type Path/Query String/HTTPBody Description
Spreadsheet File FormData The spreadsheet file to be processed. Supported formats include XLSX, XLS, ODS, CSV, etc.
removeTextMethod String Query Specifies the text removal method type. Options: None (no removal), RemoveCustomCharacter (remove specific custom characters), RemoveCharacterSets (remove predefined character sets), RemoveSubString (remove specified substrings). Default is None.
characterSets String Query Specifies the predefined character set(s) to remove when RemoveCharacterSets is selected. Options: NonPrintingCharacters, TextCharacters, NumericCharacters, Symbols, PunctuationMarks. Multiple sets can be combined using commas.
removeCustomValue String Query Specifies the custom character(s) or substring(s) to remove when using RemoveCustomCharacter or RemoveSubString method.
worksheet String Query (Optional) The name of the worksheet where text removal will be applied. If omitted, the operation applies to the first worksheet.
range String Query (Optional) The cell range where text removal will be applied (e.g., "A1:C10"). If omitted, the operation applies to all used cells in the specified worksheet.
outPath String Query (Optional) The cloud storage folder path where the processed workbook will be saved. If omitted, the file is saved in the source folder.
outStorageName String Query The name of the cloud storage where the output file will be stored.
region String Query (Optional) Sets the locale for character set definitions, particularly relevant for language-specific character handling (e.g., "en-US", "ja-JP").
password String Query (Optional) If the uploaded spreadsheet is password-protected, provide the password to open and process the file.

Response

{
File
}

Error Codes

  • 400 Bad Request: Invalid Aspose.Cells Cloud API URI.
  • 401 Unauthorized: Invalid access token. Or invalid client id and secret.
  • 404 Not Found: The spreadsheet file not accessible.
  • 500 Server Error: The spreadsheet has encountered an anomaly in obtaining calculation data.

Where should we use the Remove Characters API?

  • Data Import/Export: Clean imported csv/data by removing invisible characters and formatting errors
  • Database Management: Standardize product codes, IDs, and names by removing unwanted symbols/punctuation
  • Financial Analysis: Extract pure numbers by stripping currency symbols and text characters
  • Text Processing: Remove line breaks, tabs for clean text analysis and reporting
  • Inventory Management: Clean product names by eliminating redundant prefixes/suffixes

Why should you use the Remove Characters API?

  • Save Time: Bulk remove multiple character types instantly vs manual cleaning
  • Ensure Accuracy: Eliminate hidden characters that cause analysis errors and formatting issues
  • Standardize Data: Achieve consistent formatting across datasets and systems
  • Improve Analysis: Get clean, analysis-ready data by isolating numbers or text as needed
  • Fix Import Errors: Remove problematic characters that break databases and formulas
  • Developer-Friendly: Aspose.Cells Cloud offers SDK libraries in multiple languages, enabling quick development and comes with comprehensive documentation. Compared to building custom chart rendering solutions, this significantly reduces the development workload.
  • Cost-Effective: You can remove characters without first uploading the workbook, which saves storage space and reduces costs.

OpenAPI Specification

The OpenAPI Specification defines a publicly accessible programming interface and lets you carry out REST interactions directly from a web browser.

Use Aspose.Cells Cloud SDKs

Using the SDK is the best way to accelerate development. The SDK handles the underlying details, allowing you to simply implement Remove characters for cells with minimal code. Please check out the GitHub repository for a complete list of Aspose.Cells Cloud SDKs.

The following code examples illustrate how to make calls to Aspose.Cells web services using various SDKs: