Straighting out a ceel

[Richard]

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?

 

[Don Guillett]

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

 

[Richard]

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

 

[Paul Hyett]

In microsoft.public.excel on Wed, 19 Dec 2007, Richard

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?

 

[Don Guillett]

So, how about two columns

 

[Richard]

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

 

[Stan Brown]

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"?