Excel's TRIM function removes extra spaces in cells
4:20
Added: 3 years ago
From: DannyRocksExcels
Views: 6,630
Sort by time | Sort by thread (beta)

Link to this comment:

Share to:

All Comments (5)

Sign In or Sign Up now to post a comment!

  • Thanks just what I needed for one of my projects.

    ncvideoprimeinc 1 month ago

  • @ncvideoprimeinc

    My pleasure. I am happy that I could help you with your project.

    Danny Rocks

    The Company Rocks

    DannyRocksExcels 1 month ago

  • Thank you - this was exactly what I needed and had a few extras I'll hold onto.

    Hydee126 2 months ago

  • @Hydee126

    My pleasure! I am happy that I could help you to understand how to use these TEXT Functions in Excel.

    Danny Rocks

    The Company Rocks

    DannyRocksExcels 2 months ago

  • Thanks for the info! It helped me convert some numbers that were presented as "17 040 945" with spaces instead of commas for the 1000's places. Though I ended up having to do a text to column since the trim didnt work on single cells, so I split them out, then recombined using the trim(&&&) command you have shown here.

    Surannhealz 2 years ago

Loading...
Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more