Cells not Aligning Properly

Bill Bisco

Active Member
Joined
Aug 8, 2007
Messages
446
Hi all,

I have several accumulated values from other spreadsheets on my spreadsheet and I'm combining and organizing them on mine. However, the cell alignment isn't working properly as you can see in the picture below.

notalignedproperlyp.jpg


Now, I can certainly retype these values and align them and they'll align all nice and neat; however, I have a huge Column and retyping that column would take an inordinate amount of time.

I searched earlier on cell alignment and couldn't find anything. Any help is appreciated.

Sincerely,
Bill
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
Bill do you have extra characters in the cells that you don't know about?

You could try using a trim formula in another column to see if that resloves and align the new column if it works you can then do a little of VBA to correct this.

Also what you are showing has numbers as well as text, so numbers will default to the right and text would normally go to the left, and finally do you have indents on in the cell which you don't know about?
 
Last edited:
Upvote 0
Hi there,

I had the situation before one month in my office while I was working on a data which was extracted from different pdf's.

What i did was:


Just select the entire column, Now, select the TOP and LEFT Align, and Again Do the Same.

It will automatically according to the Alignment. Now, I just Put my alignment specifications.

This way worked for me.

In other reason, May be some other special charaters as above Said.

If it is possible, post a samle worksheet. :)
 
Upvote 0
Thank you both. The TRIM() Function worked perfectly for me. I'm not entirely sure why either, but my issue is solved. Thank you! :biggrin:

An example file before and after trim is here
 
Upvote 0

Forum statistics

Threads
1,213,552
Messages
6,114,278
Members
448,559
Latest member
MrPJ_Harper

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top