How do i add " to the beginning of all cells

Y

yvanblo

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

Richard Neville

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::\::=.
 
Y

yvanblo

The problem is not all of the cells say DisableChangePassword, they AL
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 cod
or more, that all need this done to them. That would be alot of typin
to put them all in one at a time.

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

swatsp0p

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 t
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?

Bruc
 
Top