+ Reply to Thread
Results 1 to 4 of 4

How do I automatically change text

  1. #1
    Monty
    Guest

    How do I automatically change text

    I would like to automatically change the text in a series of cells.
    For example the value currently shown in the cell is "
    00/05-05-097-5W5/00 ". How would I remove the 00/ & /00, so the cell
    would show " 05-05-097-5W5 "?
    I hope this is not too confusing. Thanks Monty

  2. #2
    Myrna Larson
    Guest

    Re: How do I automatically change text

    Search and replace? Search for 00/ and replace with <space>, ditto for /00


    On 15 Mar 2005 21:39:09 -0800, mleeds@hitechfluid.com (Monty) wrote:

    >I would like to automatically change the text in a series of cells.
    >For example the value currently shown in the cell is "
    >00/05-05-097-5W5/00 ". How would I remove the 00/ & /00, so the cell
    >would show " 05-05-097-5W5 "?
    >I hope this is not too confusing. Thanks Monty



  3. #3
    Biff
    Guest

    How do I automatically change text

    Hi!

    Select the range in question
    Goto Edit>Find
    Find what: 00/
    Replace with: nothing, leave this blank.
    Click Find All
    Now, if you have other entries like this in other
    locations on your sheet and you do not want those to be
    changed then in the little box that lists all instances of
    the text found in the range, to replace, select all the
    entries listed and then click Replace. If you don't have
    other entries like this then click Replace All. Clicking
    Replace All will replace every instance found anywhere on
    the sheet so you need to exercise a little caution.

    Then repeat the process for /00.

    OR, you could use a helper column and use this formula:

    =SUBSTITUTE(SUBSTITUTE(A1,"00/",""),"/00","")

    Copy down as needed. Then select all those formulas and do
    a Copy/Paste Special Values. Delete the original list.

    Biff

    >-----Original Message-----
    >I would like to automatically change the text in a series

    of cells.
    >For example the value currently shown in the cell is "
    >00/05-05-097-5W5/00 ". How would I remove the 00/ & /00,

    so the cell
    >would show " 05-05-097-5W5 "?
    >I hope this is not too confusing. Thanks Monty
    >.
    >


  4. #4
    Monty
    Guest

    Re: How do I automatically change text

    Thanks for the help.

    Monty

+ 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