---
schema_version: "1"
id: 723c6dc110dc2cbb5904bd8cb9f7b9c3e3bd287e0db48237612463d8321801d2
title: Handle Text Values
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/bi_integrate_text_column_handling.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_text_column_handling.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: f88a6be5927989a977a2dd0f6c17d06da2bc3bd500034bc728f1f4afd29348c4
description: Confirm that text values in a column are uniform in formatting, spelling, and language. Inconsistencies can occur within data sources and after merging data from multiple data sources.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# Handle Text Values

Confirm that text values in a column are uniform in formatting, spelling, and language. Inconsistencies can occur within data sources and after merging data from multiple data sources.

To ensure that your data is grouped properly during analysis, standardize the text strings used for dimensions.

- Use the [Bucket transformation](https://help.salesforce.com/articleView?id=bi_integrate_data_prep_recipe_bucket_dim.htm&type=0&language=en_US) to replace similar values with a consistent value. For example, replace abbreviations with full text strings, or replace text strings with abbreviations.
- Fix other spelling inconsistencies, such as typographical errors, plurals, uppercase and lowercase characters, and so on.
- Use a [column profile](https://help.salesforce.com/articleView?id=bi_integrate_recipe_column_profile_suggestions.htm&type=5&language=en_US) in CRM Analytics to review string length. For example, some column values require the same length, such as a 5-digit zip code or 10-digit phone number.