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!!


--
yvanblo
------------------------------------------------------------------------
yvanblo's Profile: http://www.excelforum.com/member.php...o&userid=26099
View this thread: http://www.excelforum.com/showthread...hreadid=394314

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" wrote in
message ...

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

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!


--
yvanblo
------------------------------------------------------------------------
yvanblo's Profile: http://www.excelforum.com/member.php...o&userid=26099
View this thread: http://www.excelforum.com/showthread...hreadid=394314

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 CopyPaste SpecialValues to overwrite the old cells.
Finally, delete the helper column.

Will this work for you?

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=394314