Bullets & tabbing

[Guest]

Couple questions related to text in cells: How can I insert a tab position
and is there any way to have the text get bullets or numbering

 

[Dave Peterson]

Tabs don't work the same way in excel as they do as in a Word table.

You can add a tab like:
="asdf"&char(9)&"qwer"
But you'll see a little box where the tab (char(9)) would be.

About the only option you have is to use the spacebar (as many times as you
want).

And if you want things to line up, you'll probably want to use a fixed width
font--I like Courier New.

You can insert bullets or numbering manually--excel doesn't have anything built
into it like MSWord.

Insert|Symbol (for xl2002+)
or
Chip Pearson has an addin that may help (if you're using xl2k or lower).
http://www.cpearson.com/excel/download.htm
(look for Symbolizer and make sure you get the correct version)

Or you could use:
Using Windows CharMap
Windows start button|run
charmap
and hit enter
Then you can find a bullet and paste.

Remember, you'll have to change the font for that character, too.

 

[Dave Peterson]

In fact, if this is really important to you, you may want to use a table within
MSWord. You'll be able to use all MSWord's formatting capabilities.

 

[William]

Hi Dave

Rather than using tabs, you could try using Excel's "indent" tool.

To use bullet points with text in cells, format the cells as
". @"

To use bullet points with numbers in cells, format the cells as
". #,##0"

The first digit of the formatting (which looks like a full stop above)
should be entered using "Alt0149" - the bullet point does not come out in
plain text posts.

--


XL2003
Regards

William
(e-mail address removed)