Hello all, I am using Excel 2013.
I have multiple columns w/ addresses (only the numbers, not the streets). I would like for odd ending numbers to be left-aligned and even ending numbers right-aligned.
Is there a formula or macro (if any) that I can utilize to select all the cells within a column and align these accordingly?
I searched here, kb's, and elsewhere but could not find anything helpful.
Thank you in advance.
I have multiple columns w/ addresses (only the numbers, not the streets). I would like for odd ending numbers to be left-aligned and even ending numbers right-aligned.
Is there a formula or macro (if any) that I can utilize to select all the cells within a column and align these accordingly?

I searched here, kb's, and elsewhere but could not find anything helpful.
Thank you in advance.