Straighting out a ceel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Richard - 19 Dec 2007 15:26 GMT

I have a thousand cells that take up a thousand rows with information in
them and at the far right of each cell I have a note like: info 1, info 2
info 3. What I wanted to do is line that peace of information in a straight
line within each cell. Trying to do it manually is a pain and never comes
out straight. Anyway is there anyway I can do this?

Reply to this Message

Don Guillett - 19 Dec 2007 15:52 GMT

Unless I am missing something there should be a right align button on your
toolbar. If not, use format>cells>alignment

Signature

Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com

>I have a thousand cells that take up a thousand rows with information in
>them and at the far right of each cell I have a note like: info 1, info 2
>info 3. What I wanted to do is line that peace of information in a straight
>line within each cell. Trying to do it manually is a pain and never comes
>out straight. Anyway is there anyway I can do this?

Reply to this Message

Richard - 20 Dec 2007 01:27 GMT

I'm not talking about aligning the entire cell just the data at the right
side

> Unless I am missing something there should be a right align button on your
> toolbar. If not, use format>cells>alignment
[quoted text clipped - 4 lines]
>>straight line within each cell. Trying to do it manually is a pain and
>>never comes out straight. Anyway is there anyway I can do this?

Reply to this Message

Paul Hyett - 20 Dec 2007 09:35 GMT

In microsoft.public.excel on Wed, 19 Dec 2007, Richard
<miller6708@cox.net> wrote :

>>>I have a thousand cells that take up a thousand rows with information
>>>in them and at the far right of each cell I have a note like: info 1,
[quoted text clipped - 9 lines]
>> SalesAid Software
>> dguillett1@austin.rr.com

>I'm not talking about aligning the entire cell just the data at the
>right side

Sounds complicated, potentially involving 'text-to-columns' and
Concatenating?

Signature

Paul Hyett, Cheltenham (change 'invalid83261' to 'blueyonder' to email me)

Reply to this Message

Don Guillett - 20 Dec 2007 12:55 GMT

So, how about two columns

Signature

Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com

> In microsoft.public.excel on Wed, 19 Dec 2007, Richard
> <miller6708@cox.net> wrote :
[quoted text clipped - 18 lines]
> Sounds complicated, potentially involving 'text-to-columns' and
> Concatenating?

Reply to this Message

Richard - 20 Dec 2007 13:52 GMT

An extra column won't work. My spread sheet is 2,000 rows and 3 columns and
I just need to get some data to the right side which I think I can do with
margins but I don't know how, does anyone know?

> So, how about two columns
>
[quoted text clipped - 20 lines]
>> Sounds complicated, potentially involving 'text-to-columns' and
>> Concatenating?

Reply to this Message

Stan Brown - 21 Dec 2007 10:01 GMT

Thu, 20 Dec 2007 06:52:55 -0700 from Richard <miller6708@cox.net>:

> An extra column won't work. My spread sheet is 2,000 rows and 3 columns and
> I just need to get some data to the right side which I think I can do with
> margins but I don't know how, does anyone know?

You're trying to make Excel do something it's not designed to do.
Formatting of pieces within a cell is very limited compared to a word
processor.

The advice to break that information out into a separate column was
good advice -- why do you think it "won't work"?

Signature

Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/
"If there's one thing I know, it's men. I ought to: it's
been my life work." -- Marie Dressler, in /Dinner at Eight/

Reply to this Message