ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   how to use tab within a cell (https://www.excelbanter.com/excel-programming/343574-how-use-tab-within-cell.html)

Pierre via OfficeKB.com[_2_]

how to use tab within a cell
 
Hi,

can anybody explain to me how to use tab within a cell?
Thanks,
Pierre


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200510/1

Dave Peterson

how to use tab within a cell
 
Excel doesn't work well with tabs in the cell.

You can use a formula:

="this is " & char(9) & " a tab"

But all you'll see is a little box.

The best I can do in excel is use spaces.

===
Or use a table in MSWord and use ctrl-tab in that cell.

"Pierre via OfficeKB.com" wrote:

Hi,

can anybody explain to me how to use tab within a cell?
Thanks,
Pierre

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200510/1


--

Dave Peterson


All times are GMT +1. The time now is 11:42 AM.

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