Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: TRIM

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    Regina, Canada
    Posts
    79
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    is there a way to apply TRIM to a whole column instead of cell by cell?

  2. #2
    MrExcel MVP Barrie Davidson's Avatar
    Join Date
    Feb 2002
    Location
    Winnipeg
    Posts
    2,330
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-02-19 06:22, Tyre wrote:
    is there a way to apply TRIM to a whole column instead of cell by cell?
    What are you trying to do? How about using Data|TextToColumns and specifying Fixed Length for you data type? You could then trim off what you want.
    Barrie Davidson

    "You're only given a little spark of madness. You mustn't lose it." - Robin Williams

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Regina, Canada
    Posts
    79
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    thanks that worked
    what I was doing was trying to sort data from 2 sheets (combined into one)
    1 sheet (I think was converted from Lotus123), and tho the data looked the same, it acted like there were preceedign spaces in the one column of data. I know TRIM applied to the data in the cell will eliminate the problem, but I had 1000 cells to trim.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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