Results 1 to 3 of 3
  1. #1
    4 Star Lounger
    Join Date
    May 2002
    Location
    US
    Posts
    439
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Purge Cell when it contains a 'defined' character (2003)

    greetings,

    Here is what I have. I import a rather large file, not in number of rows (usually 700-800), but in the number of Cols (245) The way the file is generated, if the information being gathered is "empty" they embed one (1) space. Now, I cannot change the way they create the file so, what I am looking for is to have a macro to find the cell(s) that contain the condition where the Cell ONLY contains 1 space, then remove the space.

    There would be no other data in the cell. Just the one space.

    Thoughts?


    Thanks,
    Brad

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Purge Cell when it contains a 'defined' character (2003)

    See <post:=698,173>post 698,173</post:>.

  3. #3
    4 Star Lounger
    Join Date
    May 2002
    Location
    US
    Posts
    439
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Purge Cell when it contains a 'defined' character (2003)

    Coolness...


    thanks!
    Brad

Posting Permissions

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