Skip to content
Skip to content
Menu
Alchemex
  • Products
    • Sage Intelligence Reporting
      • Enrolment
    • Velixo
      • Enrolment
        • Velixo for Acumatica
        • Velixo for Sage Intacct
  • Services
    • Consulting
    • Training
    • Development
  • Support
    • Support Overview
    • Create Support Ticket
    • Book A Session
    • Knowledgebase
  • About
    • About Us
  • Contact
Alchemex

Use the TRIM function in Excel to easily remove spaces between data

By admin on March 19, 2016

Are you constantly battling with the task of having to manually remove leading spaces between data? Now you can easily remove spaces from your data, except for single spaces between words, using the TRIM function from Microsoft® Excel®.
Assuming you have imported data with irregular spacing into Excel an worksheet, in this tip we’ll show you how your data can easily be cleaned up by applying the TRIM function. 
Note: You are welcome to download the workbook to practice.
Applies To: Microsoft® Excel® 2010 and 2013.
1.         For this tip, the screen shot below will be used as an example

2.         Select cell C2 and type: =TRIM(B2)
3.         Press enter and copy the formula down the column to where your data ends.

After trying the exercise you will see that the leading spaces have been removed from your data using the TRIM function. So, you no longer need to waste time by manually do this, thus saving you time and making your worksheet look more neat and tidy.
The post Use the TRIM function in Excel to easily remove spaces between data appeared first on Sage Intelligence.

Powered by WPeMatico

Post navigation

Use the MID and FIND functions in Excel to easily link a worksheet to a cell
Learn how to easily combine reporting periods in Sage Intelligence Reporting formulas

Recent Posts

  • Why Working In Excel Works
  • Alchemex Welcomes Velixo 6 For MYOB Advanced
  • Welcome to Velixo Reports Version 4.2
  • Part 3 of 3: Learn how to create a Management Pack in Sage 50cloud Intelligence
  • Part 3 of 3: Create and customize reports easily with the Financial Report Designer

Search

Contact Us

Phone: +61 2 9890 2339
Email: sales@alchemex.com.au
Address: PO Box 212, Deaken West, Canberra, Australia, 2600
©2025 Alchemex | WordPress Theme by SuperbThemes.com