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

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

Trevor G

Well-known Member
Joined
Jul 17, 2008
Messages
6,708
Office Version
  1. 2016
Platform
  1. Windows
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:

krishhi

Active Member
Joined
Sep 8, 2008
Messages
328
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. :)
 

Bill Bisco

Active Member
Joined
Aug 8, 2007
Messages
446
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
 

Forum statistics

Threads
1,175,651
Messages
5,898,671
Members
434,721
Latest member
Zaimuddin

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
Top