I know how to add bullet points generally to and excel cell. The problem I am having is I already have multiple lines of text in one cell in a giant spreadsheet someone else made.
We want to use bullet point to show where the new line of text is in each cell
And I have not been able to figure out how to do it as amaster group. I know I could go in to each cell put the cursor at the start ofthe first line and do the ALT 7 then manually move to the next line and do thesame thing but I have over 1600 cells that need these adjustments.
ASo you can see in the first examples I manually added 2bullets to the corrections officer 1 and 2 but I don’t want to have to do thatmanually thousands of times. The other 2 don’t have bullets yet.
<colgroup><col width="77" style="width: 58pt; mso-width-source: userset; mso-width-alt: 2816;">
<col width="247" style="width: 185pt; mso-width-source: userset; mso-width-alt: 9033;">
<col width="117" style="width: 88pt; mso-width-source: userset; mso-width-alt: 4278;">
<col width="133" style="width: 100pt; mso-width-source: userset; mso-width-alt: 4864;">
<col width="111" style="width: 83pt; mso-width-source: userset; mso-width-alt: 4059;">
<col width="113" style="width: 85pt; mso-width-source: userset; mso-width-alt: 4132;">
<col width="45" style="width: 34pt; mso-width-source: userset; mso-width-alt: 1645;">
<col width="70" style="width: 53pt; mso-width-source: userset; mso-width-alt: 2560;">
<col width="53" style="width: 40pt; mso-width-source: userset; mso-width-alt: 1938;">
<col width="88" style="width: 66pt; mso-width-source: userset; mso-width-alt: 3218;">
<col width="64" style="width: 48pt; mso-width-source: userset; mso-width-alt: 2340;">
<col width="255" style="width: 191pt; mso-width-source: userset; mso-width-alt: 9325;">
<col width="120" style="width: 90pt; mso-width-source: userset; mso-width-alt: 4388;">
<col width="124" style="width: 93pt; mso-width-source: userset; mso-width-alt: 4534;">
<col width="113" style="width: 85pt; mso-width-source: userset; mso-width-alt: 4132;">
<col width="117" style="width: 88pt; mso-width-source: userset; mso-width-alt: 4278;">
<tbody>
</tbody>
Any help would be great.
We want to use bullet point to show where the new line of text is in each cell
And I have not been able to figure out how to do it as amaster group. I know I could go in to each cell put the cursor at the start ofthe first line and do the ALT 7 then manually move to the next line and do thesame thing but I have over 1600 cells that need these adjustments.
ASo you can see in the first examples I manually added 2bullets to the corrections officer 1 and 2 but I don’t want to have to do thatmanually thousands of times. The other 2 don’t have bullets yet.
47230 | Corrections Officer 3 | 47230 | Corrections | 11/21/2018 | 12/12/2018 | x | x | x | x | • Corrections Officer 1 • Corrections Officer 2 | 12 | 12 | Higher than Unsatisfactory | ||
22060 | Education Administration Associate | 93153 | Education | 11/26/2018 | 12/14/2018 | x | x | x | x | x | Administrative Assistant 2 Administrative Officer 1 | 12 | 24 | Satisfactory or higher | |
47230 | Corrections Officer 3 | 31248 | Corrections | 11/27/2018 | 12/12/2018 | x | x | x | x | Corrections Officer 1 Corrections Officer 2 | 12 | 12 | Higher than Unsatisfactory |
Any help would be great.