Remove trailing space in Open Office spreadsheets?

Discussion in 'Computer Support' started by Evan Platt, Aug 28, 2006.

  1. Evan Platt

    Evan Platt Guest

    Working on a spreadsheet in Open Office. Copying and pasting from a
    website, there's a space after the last word in each column.

    Is there a way to remove this space? I can't do a replace for " "
    because there can be a space in the middle, just no space at the end.
    So "Left Field " should be "Left Field"

    Thanks.

    Evan
     
    Evan Platt, Aug 28, 2006
    #1
    1. Advertising

  2. Evan Platt

    edgy Guest

    "Evan Platt" <> wrote in message
    news:...
    > Working on a spreadsheet in Open Office. Copying and pasting from a
    > website, there's a space after the last word in each column.
    >
    > Is there a way to remove this space? I can't do a replace for " "
    > because there can be a space in the middle, just no space at the end.
    > So "Left Field " should be "Left Field"
    >
    > Thanks.
    >
    > Evan


    does Open Office do macros like Microsoft Word?

    Then try end-backspace-tab and copy that as many times as necessary!
     
    edgy, Aug 28, 2006
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Hansang Bae
    Replies:
    1
    Views:
    966
    shope
    Jul 9, 2003
  2. ~*Eternity*~

    Printing spreadsheets

    ~*Eternity*~, Jan 3, 2004, in forum: Computer Support
    Replies:
    4
    Views:
    525
    Gordon
    Jan 3, 2004
  3. David Hemingsley

    SPREADSHEETS

    David Hemingsley, Nov 22, 2004, in forum: Computer Support
    Replies:
    11
    Views:
    762
    =?ISO-8859-1?Q?R=F4g=EAr?=
    Nov 23, 2004
  4. Dmitriy

    Hauppauge WinTV PVR-150 MCE - trailing images

    Dmitriy, Dec 6, 2004, in forum: Computer Support
    Replies:
    4
    Views:
    846
    Dmitriy
    Dec 9, 2004
  5. Dmitriy

    Need help with image trailing n MPEG2 stream

    Dmitriy, Dec 26, 2004, in forum: Computer Support
    Replies:
    2
    Views:
    501
    Dmitriy
    Dec 27, 2004
Loading...

Share This Page