Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do you "select locked cells" w/o "select unlocked cells"? | Excel Discussion (Misc queries) | |||
Deselect Cells while using ctrl | Excel Discussion (Misc queries) | |||
Counting only active cells | Excel Discussion (Misc queries) | |||
Help adding text values | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |