Text Alignment

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am having a problem with Excel, I try to center the Column but it still
staggers the data. Here is an example

Component
109591305
405762857-6
408809705
848619391
848939559
848945135
848950739
848950770
848960142
848960456
901278010-4
901311266-4
901325373-4
901391177-4

Also, When I try to edit some of the cells in different areas of the spread
sheet, it will only allow me to do so in the tool bar, and not in the cell,
or vice versa.

Finally, When I paste something from our mainframe (it is three lines
long)...

LOCKWASHER SPLIT M5X5.1X9.2MM
STNLESS STEEL NATURAL FINISH
DIN 127 TYPE B 1987

It pastes into 3 cells, how can I make this paste into one cell. Merge
cells is off.

Thank You in advance!
Ben
 
For the second part (paste into a single cell) click in the formula bar
rather than a cell and then paste.
 
I am having a problem with Excel, I try to center the Column but it still
staggers the data. Here is an example

Component
109591305
405762857-6
408809705
848619391
848939559
848945135
848950739
848950770
848960142
848960456
901278010-4
901311266-4
901325373-4
901391177-4
Click to expand...


The problem is most likely due to leading spaces prior to the entries that
appear right justified.

In an adjacent column, enter =TRIM(A1) and fill down as needed. You should
then be able to center the data. You can then do a copy/paste special/values
back over the original to get rid of it; or merely hide that column

Also, When I try to edit some of the cells in different areas of the spread
sheet, it will only allow me to do so in the tool bar, and not in the cell,
or vice versa.
Click to expand...

I can't answer that.
Finally, When I paste something from our mainframe (it is three lines
long)...

LOCKWASHER SPLIT M5X5.1X9.2MM
STNLESS STEEL NATURAL FINISH
DIN 127 TYPE B 1987

It pastes into 3 cells, how can I make this paste into one cell. Merge
cells is off.
Click to expand...


Select the target cell, then paste into the formula bar, and not into the cell.


Thank You in advance!
Ben
Click to expand...

--ron
 
Your data probably has imbedded spaces at the beginning and/or the end.

With your data in A1 to A14, enter this formula in B1:

=TRIM(A1)

and copy down.

NOW ... center Column B.

If this works, you might wish to remove the formula and leave just the data
behind by selecting the cells in Column B with the data, then right click in
the selection and choose "Copy".
Right click again, and choose "Paste Special", click on "Values", then <OK>.

You now have *only* data in Column B, and you might want to delete the
original data in Column A.
 
Back
Top