+ Reply to Thread
Results 1 to 4 of 4

How do i add " to the beginning of all cells

  1. #1
    Registered User
    Join Date
    08-09-2005
    Posts
    2

    How do i add " to the beginning of all cells

    I have a login script that has lost its quote marks. example:
    DisableChangePassword=dword:00000001

    It should read:
    "DisableChangePassword"=dword:00000001

    I have already added the quotes to the far side: DisableChangePassword"=dword:00000001 But i am having trouble adding the first quote mark.

    Oh by the way there are over 500 entries to be made, so one at a time is not what i want to do. Also not all rows need the quote marks.
    Thank you for your help!!

  2. #2
    Richard Neville
    Guest

    Re: How do i add " to the beginning of all cells

    You could use the Replace function. In the "Find what" box, enter the word
    Disable. In "Replace with, enter ::\::Disable. Try it on a couple of cells;
    if it works, click Replace All. Then "Find what" Password=, "Replace with"
    Password::\::=.

    "yvanblo" <[email protected]> wrote in
    message news:[email protected]...
    >
    > I have a login script that has lost its quote marks. example:
    > DisableChangePassword=dword:00000001
    >
    > It should read:
    > ::\"::DisableChangePassword::\"::=dword:00000001
    >
    > I have already added the quotes to the far side:
    > DisableChangePassword::\"::=dword:00000001 But i am having trouble
    > adding the first quote mark.
    >
    > Oh by the way there are over 500 entries to be made, so one at a time
    > is not what i want to do. Also not all rows need the quote marks.
    > Thank you for your help!!
    >
    >
    > --
    > yvanblo
    > ------------------------------------------------------------------------
    > yvanblo's Profile:
    > http://www.excelforum.com/member.php...o&userid=26099
    > View this thread: http://www.excelforum.com/showthread...hreadid=394314
    >




  3. #3
    Registered User
    Join Date
    08-09-2005
    Posts
    2

    Reply to richard

    The problem is not all of the cells say DisableChangePassword, they ALL say something different. Example:
    AdvancedTab"=dword:00000000
    ConnectionsTab"=dword:00000000
    Connwiz Admin Lock"=dword:00000000
    ContentTab"=dword:00000000
    FormSuggest Passwords"=dword:00000000
    GeneralTab"=dword:00000000
    HomePage"=dword:00000000
    Messaging"=dword:00000000

    And again notice the quote mark on only the left side of the comment. Also, i have 7 or 8 different files, each containing 250 lines of code or more, that all need this done to them. That would be alot of typing to put them all in one at a time.

    Thanks for the help Richard, let me know if there is a way to use the same technique for all of these different names, maybe a wild card or something. Thanks!

  4. #4
    Forum Expert swatsp0p's Avatar
    Join Date
    10-07-2004
    Location
    Kentucky, USA
    MS-Off Ver
    Excel 2010
    Posts
    1,545
    Is it possible to add a helper column? Then, in an unused cell (e.g. IV1) enter a quote mark.

    In your helper column enter the formula:

    =$IV$1&B1 (where B1 is the first cell with your desired text to update)

    Copy this to the other cells needing updating.

    You can then Copy>Paste Special>Values to overwrite the old cells. Finally, delete the helper column.

    Will this work for you?

    Bruce
    Bruce
    The older I get, the better I used to be.
    USA

+ 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