+ Reply to Thread
Results 1 to 2 of 2

Find & replace problems

  1. #1
    Registered User
    Join Date
    08-30-2006
    Posts
    40

    Angry Find & replace problems

    I've got a spreadsheet that decided today that it just doesn't like me anymore. Can someone help me fix it? I've written a macro that scrapes 4 pages of notes out of my mainframe systems and combines them into 1 big string in excel...then removes all the extra dashes (unused notes fields in our mainframe system have dashes in them) using a find & replace command. So basically it scrapes this info out of the mainframe:

    ****12/28/06 USG5224 SLA 12/29 OE 1211933 H6 626 657 425-------------------- ********12/28/06 USG5803 ------------------------------------------------------- ------------------------------------------------------- ------------------------------------------------------- ------------------------------------------------------- ------------------------------------------------------- ------------------------------------------------------- ------------------------------------------------------- ------------------------------------------------------- -------------------------------------------------------------------------------------------------------------- ------------------------------------------------------- ------------------------------------------------------- ------------------------------------------------------- ------------------------------------------------------- ------------------------------------------------------- ------------------------------------------------------- ------------------------------------------------------- ------------------------------------------------------- -------------------------------------------------------------------------------------------------------------- ------------------------------------------------------- ------------------------------------------------------- ------------------------------------------------------- ------------------------------------------------------- ------------------------------------------------------- ------------------------------------------------------- ------------------------------------------------------- ------------------------------------------------------- -------------------------------------------------------------------------------------------------------------- ------------------------------------------------------- ------------------------------------------------------- ------------------------------------------------------- ------------------------------------------------------- ------------------------------------------------------- ------------------------------------------------------- ------------------------------------------------------- ------------------------------------------------------- -----------------------------------


    and turns it into this:

    ****12/28/06 USG5224 SLA 12/29 OE 1211933 H6 626657425********12/28/06 USG5803

    I've been using this macro every day for several months now & its never had any problems...but for some reason today it didn't remove the dashes. When I manually use find & replace to remove them by finding all occurences of "-" and replacing them with "", I get an error message that says "Formula is too long." Anybody have any clue what I might have screwed up?

  2. #2
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,195
    Quote Originally Posted by Bill-E-BoB
    I've got a spreadsheet that decided today that it just doesn't like me anymore. Can someone help me fix it? I've written a macro that scrapes 4 pages of notes out of my mainframe systems and combines them into 1 big string in excel...then removes all the extra dashes (unused notes fields in our mainframe system have dashes in them) using a find & replace command. So basically it scrapes this info out of the mainframe:

    ****12/28/06 USG5224 SLA 12/29 OE 1211933 H6 626 657 425-------------------- ********12/28/06 USG5803 and turns it into this:

    ****12/28/06 USG5224 SLA 12/29 OE 1211933 H6 626657425********12/28/06 USG5803

    I've been using this macro every day for several months now & its never had any problems...but for some reason today it didn't remove the dashes. When I manually use find & replace to remove them by finding all occurences of "-" and replacing them with "", I get an error message that says "Formula is too long." Anybody have any clue what I might have screwed up?
    Hi,

    'Formula'?

    that seems to indicate a = as the first character, which you do not show.

    If there is a = as the first, preceed it with '

    If not, try (on a copy) to replace the - with nothing, and see what's left.

    Let me know how you go.
    ---
    Si fractum non sit, noli id reficere.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1