ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Entering a tab character in a cell in excel (https://www.excelbanter.com/excel-discussion-misc-queries/158035-entering-tab-character-cell-excel.html)

FAtristain

Entering a tab character in a cell in excel
 
I want to enter some text in a cell then separate it with a tab and then add
some more text in the same cell to make them "align". Something like:

Some Some More
Some again Some More again
And again And more again

PS: It does not have to be a tab character in as much as there is a way to
make the text align when entered in the same cell.

Thanks,

Bernard Liengme

Entering a tab character in a cell in excel
 
Why not use two columns?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"FAtristain" wrote in message
...
I want to enter some text in a cell then separate it with a tab and then
add
some more text in the same cell to make them "align". Something like:

Some Some More
Some again Some More again
And again And more again

PS: It does not have to be a tab character in as much as there is a way
to
make the text align when entered in the same cell.

Thanks,




FAtristain

Entering a tab character in a cell in excel
 
It is a long story but the document that I am using does not allow me to do
that.

I must enter the whole thing in one cell.

Thanks,

"Bernard Liengme" wrote:

Why not use two columns?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"FAtristain" wrote in message
...
I want to enter some text in a cell then separate it with a tab and then
add
some more text in the same cell to make them "align". Something like:

Some Some More
Some again Some More again
And again And more again

PS: It does not have to be a tab character in as much as there is a way
to
make the text align when entered in the same cell.

Thanks,





Dave Peterson

Entering a tab character in a cell in excel
 
You can use a non-proportional font (Courier New is one) and use space
characters between the phrases.



FAtristain wrote:

I want to enter some text in a cell then separate it with a tab and then add
some more text in the same cell to make them "align". Something like:

Some Some More
Some again Some More again
And again And more again

PS: It does not have to be a tab character in as much as there is a way to
make the text align when entered in the same cell.

Thanks,


--

Dave Peterson


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

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