Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Elliminating gaps between adjacent cells
I was just wondering if there was any way to eliminate the gaps between two
cells that are next to each other. I have two cells next to each other horizontally. The cell on the left is right justified and the cell on the right is left justified. I have it set up this way because I want the two cells to run togethor and look like one continuous string of text. However, while I have justified the text so that it should run togethor there is still a gap between the text (probably because of the cell boundaries). Is there any way to eliminate the gap so the two different text strings can appear to be one continuous text string? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Elliminating gaps between adjacent cells
I think you are stuck with Excel's internal padding. You may want to try
placing a text box over the cells and entering your text there. "josh meyers" wrote: I was just wondering if there was any way to eliminate the gaps between two cells that are next to each other. I have two cells next to each other horizontally. The cell on the left is right justified and the cell on the right is left justified. I have it set up this way because I want the two cells to run togethor and look like one continuous string of text. However, while I have justified the text so that it should run togethor there is still a gap between the text (probably because of the cell boundaries). Is there any way to eliminate the gap so the two different text strings can appear to be one continuous text string? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Elliminating gaps between adjacent cells
try this:
highlight both cell-- format--cell--select text...you should see space is eliminated. Nikki "josh meyers" wrote: I was just wondering if there was any way to eliminate the gaps between two cells that are next to each other. I have two cells next to each other horizontally. The cell on the left is right justified and the cell on the right is left justified. I have it set up this way because I want the two cells to run togethor and look like one continuous string of text. However, while I have justified the text so that it should run togethor there is still a gap between the text (probably because of the cell boundaries). Is there any way to eliminate the gap so the two different text strings can appear to be one continuous text string? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Elliminating gaps between adjacent cells
Hi,
You could create a formula like =a1&b1 or =a1&" "&b1 in another cell. There is a second options: 1. Left align both cells. 2. Select the left-hand cell. Click the Increase Indent button on the format toolbar a couple of times. This will put the text upto or even under the other cell, then if necessary you can resize the cell to just view the left cell's text. -- Thanks, Shane Devenshire "josh meyers" wrote: I was just wondering if there was any way to eliminate the gaps between two cells that are next to each other. I have two cells next to each other horizontally. The cell on the left is right justified and the cell on the right is left justified. I have it set up this way because I want the two cells to run togethor and look like one continuous string of text. However, while I have justified the text so that it should run togethor there is still a gap between the text (probably because of the cell boundaries). Is there any way to eliminate the gap so the two different text strings can appear to be one continuous text string? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Transpose Column With Gaps to Column With no gaps | Excel Discussion (Misc queries) | |||
By selecting cells adjacent to cells tally sheet | Excel Worksheet Functions | |||
how to copy cells which gaps exist between? | Excel Discussion (Misc queries) | |||
How do I fill (copy) nonadjacent cells to adjacent cells? | Excel Discussion (Misc queries) | |||
Transpose Column With Gaps to Row With No Gaps? | Excel Discussion (Misc queries) |