Tab within a cell

[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.

 

[Bob Phillips]

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

--

HTH

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

 

[Hari Prasadh]

Hi Bob,

Thnx for the post.
Would have wasted time in figuring out/searching.

 

[budgie]

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

To enter a TAB within an Excel cell, press Ctrl-Tab

(if that was the question)

 

[Hari Prasadh]

Hi Budgie,

Doing that I would navigate to the next Excel workbook.

 

[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.

 

[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.

 

[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.)

 

[Bob Phillips]

I didn't write that! ;-)

Bob

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.)

 

[Dave Peterson]

I gotcha. But I was guessing that budgie was thinking about MSWord.

 

[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.)

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

 

[Hari Prasadh]

Hi Myrna,

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

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.

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.