FunnyChicken5749
New Member
- Joined
- Mar 26, 2008
- Messages
- 12
Ok, so I'm working on an excel project for my mom.
She wants an excel sheet of all the websites she's a member of and the passwords she's using for each site. However, she wants the passwords to show up as "*******" so that anyone who just looks at the sheet over her shoulder doesn't know what it says.
Example (picture this in excel)
<table style="border-collapse: collapse; width: 133pt;" border="0" cellpadding="0" cellspacing="0" width="177"><col style="width: 56pt;" width="75"> <col style="width: 77pt;" width="102"> <tbody><tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 56pt;" width="75" height="20">Yahoo!</td> <td class="xl65" style="border-left: medium none; width: 77pt;" width="102">passwordY</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="border-top: medium none; height: 15pt;" height="20">Gmail</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">passwordG</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="border-top: medium none; height: 15pt;" height="20">MSN</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">passwordM</td> </tr> </tbody></table>
Expected result:
<table style="border-collapse: collapse; width: 133pt;" border="0" cellpadding="0" cellspacing="0" width="177"><col style="width: 56pt;" width="75"> <col style="width: 77pt;" width="102"> <tbody><tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 56pt;" width="75" height="20">Yahoo!</td> <td class="xl65" style="border-left: medium none; width: 77pt;" width="102">*********</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="border-top: medium none; height: 15pt;" height="20">Gmail</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">*********</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="border-top: medium none; height: 15pt;" height="20">MSN</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">*********</td> </tr> </tbody></table>
If anyone knows a code or formula that could help me with this, I would greatly appreciate it.
I took an excel class about 5 years ago, and I feel like I learned how to do this, but I have Windows Vista and Excel 2007 now and have no idea what I'm doing.
THANKS! =)
She wants an excel sheet of all the websites she's a member of and the passwords she's using for each site. However, she wants the passwords to show up as "*******" so that anyone who just looks at the sheet over her shoulder doesn't know what it says.
Example (picture this in excel)
<table style="border-collapse: collapse; width: 133pt;" border="0" cellpadding="0" cellspacing="0" width="177"><col style="width: 56pt;" width="75"> <col style="width: 77pt;" width="102"> <tbody><tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 56pt;" width="75" height="20">Yahoo!</td> <td class="xl65" style="border-left: medium none; width: 77pt;" width="102">passwordY</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="border-top: medium none; height: 15pt;" height="20">Gmail</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">passwordG</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="border-top: medium none; height: 15pt;" height="20">MSN</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">passwordM</td> </tr> </tbody></table>
Expected result:
<table style="border-collapse: collapse; width: 133pt;" border="0" cellpadding="0" cellspacing="0" width="177"><col style="width: 56pt;" width="75"> <col style="width: 77pt;" width="102"> <tbody><tr style="height: 15pt;" height="20"> <td class="xl65" style="height: 15pt; width: 56pt;" width="75" height="20">Yahoo!</td> <td class="xl65" style="border-left: medium none; width: 77pt;" width="102">*********</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="border-top: medium none; height: 15pt;" height="20">Gmail</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">*********</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl65" style="border-top: medium none; height: 15pt;" height="20">MSN</td> <td class="xl65" style="border-top: medium none; border-left: medium none;">*********</td> </tr> </tbody></table>
If anyone knows a code or formula that could help me with this, I would greatly appreciate it.
I took an excel class about 5 years ago, and I feel like I learned how to do this, but I have Windows Vista and Excel 2007 now and have no idea what I'm doing.
THANKS! =)