ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   <tab within a cell (https://www.excelbanter.com/excel-discussion-misc-queries/151958-tab-within-cell.html)

ceenia8

<tab within a cell
 
When entering text within a cell, can you put a <tab within the cell?

Don Guillett

<tab within a cell
 
IF?? you mean a second line, just use alt enter wherever you want to break
it.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"ceenia8" wrote in message
...
When entering text within a cell, can you put a <tab within the cell?



Dave Peterson

<tab within a cell
 
You could use a formula:

="some text" & char(9) & "more text"

But it won't work like a tab in MSWord. You'll see a little box instead of nice
text.

ceenia8 wrote:

When entering text within a cell, can you put a <tab within the cell?


--

Dave Peterson


All times are GMT +1. The time now is 07:42 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com