This one is easy. Most people know about this one.
Place your cursor at the beginning of the cell; hold the ALT key and on the numeric keypad only, enter 0149.
Inserting bullets in multiple cells:
Using a Formula:
This needs to be done in another column with a formula. If, for example, the text you want bulleted is in column C; then taking cell C2 as our reference we would write a formula in cell D2 – =CHAR(149)&C2) and copy down as far as you wish. You now have a bulleted list in Column D. Highlight the bulleted cells in Column D; Copy; select cell C2, and using Paste Special, paste Values. Delete the bulleted list in column D.
If you want a space between the bullet and the text, change the formula to =CHAR(149)&" "&C2). Note: There is a space between the two quotation marks.
Using Custom Formatting
Highlight the cell(s) that will have bulleted text. Go to Format, Cells, Number Tab. Under Categories, choose Text first and then choose Custom. Place your cursor before the @ sign in the Type: box. Hold the ALT key and on the numeric keypad only, enter 0149. (if you want a space between the bullet and the text, type in the space after entering 0149). Click OK to accept the Custom Format.
Inserting multiple bullets in a single cell:
(Please note:- This method works only if you have less than 1024 characters in the cell. Else, you will get an error "Formula is too long")
Type your list(s) in the cell(s) the as you need using ALT/ENTER to create each new line in the cell. Once you have typed in all your data, go to Edit, Replace. The Find and Replace dialog box will pop up. Place your cursor in the Find what: box and hold the [b][blue]ALT key and on the numeric keypad only, enter 0010. Let go of the ALT key. Place your cursor in the [b][blue]Replace with: box and Hold the ALT key and on the numeric keypad only, enter 0149. Let go of the ALT key and type in a space if you wish to have a space after the bullet. In the Replace with: box, place your cursor just before the bullet; hold the ALT key and on the numeric keypad only, enter 0010. Let go of the ALT key. Click Replace All on the Find and Replace dialog box and your list(s) will be populated with bullets except for the very first line. You can add the bullet to the first line using the method described above for "Bullet in a single cell".
Talk To Other Members