Straighting out a ceel

  • Thread starter Thread starter Richard
  • Start date Start date
R

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?
 
Unless I am missing something there should be a right align button on your
toolbar. If not, use format>cells>alignment
 
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
Click to expand...

Sounds complicated, potentially involving 'text-to-columns' and
Concatenating?
 
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?


Don Guillett said:
So, how about two columns
Click to expand...
 
Thu said:
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?
Click to expand...

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