Tab within a cell

H

Hari Prasadh

Hi,

I know how to enter a new line in a cell (alt + enter)

Please tell me for pressing a tab within a cell.
 
B

Bob Phillips

I don't believe that you can, directly or via VBA.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
M

Myrna Larson

Doing that I would navigate to the next Excel workbook.

No, you don't when you are in Edit mode. But the character ISN'T inserted into
the cell, either.
 
M

Myrna Larson

PS: You can get the tab character into a cell with a formula

="ABC"&CHAR(9)&"DEF"

What you see is a square box in the 4th position. It doesn't behave like a
tab.
 
D

Dave Peterson

But that is an excellent way to get the tab character in a cell in an MSWord
Table.

(I bet that was what you were thinking.)
 
B

Bob Phillips

I didn't write that! ;-)

Bob

Dave Peterson said:
But that is an excellent way to get the tab character in a cell in an MSWord
Table.

(I bet that was what you were thinking.)
Click to expand...
 
B

budgie

But that is an excellent way to get the tab character in a cell in an MSWord
Table.

(I bet that was what you were thinking.)
Click to expand...

Yup, that's what late nights do for concentration :-(
 
H

Hari Prasadh

Hi Myrna,
No, you don't when you are in Edit mode. But the character ISN'T inserted
into
the cell, either.
Click to expand...

Wasnt concentrating. Thnx to budgie Budgie/Dave for introducing me to a word
feature (slowly learning word as well with help from NG's)
It doesn't behave like a tab.
Click to expand...
Not able to understand/appreciate why you provided this formula. I checked
out the - character set(0-127) -- in help (Im wondering why does this
character set appear in the help file of VBA excel but not the help file of
Excel. Is this the same with the others? If yes why this demarcation? ) and
there it lists 2 Star's against the character 9. If this 9 doesnt behave
like a tab what does it do. I copied the results of this formula as it is to
MS word to check whether in other applications it might show/display the tab
behaviour. But in Word, there is only a single space between"abc" and "def"
(the square doesnt get displayed). Also if the help file says 2 star's why
is it displaying a sq. bracket. On the other hand if I replace 9 with any
number 1 through 8 it displays a sq. bracket for all cases. Funny thing is
for 1 through 8 case if i copy the result to Word then there it shows the
square bracket also.
 
Top