| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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, |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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, |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel-Match 1st text character in a string to a known character? | Excel Worksheet Functions | |||
| How do I protect the cell from users entering values in Excel? | Excel Worksheet Functions | |||
| When entering data into excel spreadsheet cell, the page just jum. | Excel Discussion (Misc queries) | |||
| When entering data into excel spreadsheet cell, the page just jump | Excel Discussion (Misc queries) | |||
| how can excel colour a cell when it has a specified character | Excel Discussion (Misc queries) | |||
Linear Mode
