Is there a formula to align odd and even numbers within cells?

[rad7even]

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.

 

[vds1]

Use this formula

=ISODD(A1)

then filter column by TRUE and align it to LEFT, vice versa.

 

[yesterdays]

=ISODD(MID(A1,MAX(IF(ISERROR(MATCH(-{0,1,2,3,4,5,6,7,8,9},-MID(A1,ROW($1:$50),1),0))=TRUE,"a",MATCH(-{0,1,2,3,4,5,6,7,8,9},-MID(A1,ROW($1:$50),1),0))),1)*1)
Ctrl Shift Enter

This work even A1 contain text and last number can be in middle of the string

 

[Peter_SSs]

Welcome to the MrExcel board!

Assuming the numbers are in column A, try this.

1. Select the column by clicking its heading label.

2. Home ribbon tab -> Conditional Formatting -> New rule -> Use a formula to determine which cells to format -> Format values where this formula is true: =ISODD(A1) -> Format... -> Number tab -> Category: select Text -> OK -> OK

 

[rad7even]

Thank you all for your prompt response. I have been manually aligning these cells for years until I was encouraged to try one of these forums. You have me learning a new function (=ISODD) and manipulating it to my advantage! I can now go to sleep comfortably and my work will now be performed in less steps, thanks to your replies. Thank you Peter_SSs for your welcome and also for your steps as they proved to be very helpful.

 

[Peter_SSs]

Thank you Peter_SSs for your welcome and also for your steps as they proved to be very helpful.

Glad it helped. See you on the forum again.

 

[István Hirsch]

This formula may also work (enter into B1 and copy down):

=IF(MOD(A1,2),""&A1,A1)