View Single Post
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

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.



DaveL wrote:

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