Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports

Results 1 to 3 of 3

Thread: Remove white space

  1. #1
    Join Date
    17th October 2005

    Remove white space

    Does anyone know how i might remove white space using excel?

    Its driving me crazy - as i have a huge list of words.

    An example

    I would like "Test -test2 -test3"

    To be "Test-test2-test3"

    The main problem is that it sees -test2 as a =functrion.

    Anyone know how i might do this?

    I would really appreciate any help.

    Excel Video Tutorials / Excel Dashboards Reports

  2. #2
    Join Date
    24th January 2003

    Re: Remove white space

    =TRIM(A1) and copy down. Then copy and paste special as values.

    Or, select the data and go to Edit>Replace and Replace " " and leave the Replace with box blank.

  3. #3
    Join Date
    4th July 2004

    Re: Remove white space

    Try the following...

    1) Select the range of cells containing your list of words

    2) Edit > Replace

    3) Find what: press the space bar and hyphen

    4) Replace with: leave empty

    5) Click 'Replace All'

    6) Click Ok

    Excel Video Tutorials / Excel Dashboards Reports

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Replies: 2
    Last Post: March 7th, 2008, 10:43
  2. White Space Around Chart
    By Excelintern in forum Excel General
    Replies: 2
    Last Post: July 11th, 2007, 23:48
  3. Remove All Text Left Of Space And The Space
    By liiv17 in forum Excel General
    Replies: 12
    Last Post: February 10th, 2007, 07:38
  4. Wasted white space Chart Area
    By markc in forum Excel General
    Replies: 2
    Last Post: September 16th, 2005, 04:48


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts