hard tab within a cell

  • Thread starter Thread starter brooke
  • Start date Start date
B

brooke

I know how to make a hard return (alt + <enter>) wihin a
cell but how do I make a hard tab within a cell with text?

For example:

Section I. (tab) blah blah blah.....


any help is great,
thanks,
Brooke
 
Hello Brooke,

I don't think there is a way.
For a tab to be different from just a bunch of spaces, there would have to
be a horizontal grid for each cell. This would give points of reference for
each consecutive tab-instruction to jump to. And you would want to be able
to assign the location of the tab-marks per cell. There are no provisions
for that in Excel. It is a lot to ask and I suppose the code tags this would
add to the description of each cell would make a spreadsheet rather
overweight. And it would lead us away from the main function of a
spreadsheet: calculation, into the domain of wordprocessing and layout...

A way to check that the tab doesn't work:

type:

="Section I."&CHAR(10)&"blah blah blah....."

Make sure you set linewrap for the cell you typed this in. This inserts the
ASCII-character 10 (the linefeed character) and produce:

Section I.
blah blah blah....

Now type:

="Section I."&CHAR(9)&"blah blah blah....."

This introduces a little rectangle betweed the two bits of text, meaning the
character number is recognized but cannot be displayed. This is the ASCII
tab-character however.

Hope this makes sense...

Have a swell day.
 
Back
Top